/*
 Navicat Premium Data Transfer

 Source Server         : localhost_sqlite
 Source Server Type    : SQLite
 Source Server Version : 3030001
 Source Schema         : main

 Target Server Type    : SQLite
 Target Server Version : 3030001
 File Encoding         : 65001

 Date: 10/06/2022 15:40:32
*/

PRAGMA foreign_keys = false;

-- ----------------------------
-- Table structure for biz_account
-- ----------------------------
DROP TABLE IF EXISTS "biz_account";
CREATE TABLE "biz_account" (
  "id" text(36) NOT NULL,
  "module_id" text(36) NOT NULL,
  "user_logon_name" text(128) NOT NULL,
  "user_display_name" text(128) NOT NULL,
  "user_password" text(512) NOT NULL,
  "telephone" text(45),
  "mobilephone" text(45),
  "email" text(45),
  "is_enabled" integer NOT NULL,
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id"),
  CONSTRAINT "biz_account_module" FOREIGN KEY ("module_id") REFERENCES "biz_module" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT
);

-- ----------------------------
-- Records of biz_account
-- ----------------------------
BEGIN;
INSERT INTO "biz_account" VALUES ('bd64eee6-f595-4ebf-a369-3e9b59cdf422', '81762d87-d4c5-483f-937f-4c0e77b534b5', 'XYZ', 'XYZ', 'oG1zbi0KVFun7XfTXxzlJw==', NULL, NULL, NULL, 1, '!QAZ2wsx', 0, '00000000-0000-0000-0000-000000000000', '2022-03-15 09:34:04.296', '00000000-0000-0000-0000-000000000000', '2022-06-10 15:23:00.047382', '6e2bb6b5-f916-4d26-be00-8dd7d21e3ec3');
INSERT INTO "biz_account" VALUES ('e353c06a-78d3-4366-b951-1759894913af', '4a6798ec-0296-4516-9618-bd66cb77fa53', 'ABC', 'ABC', 'BVm4iKPKu1/MPYhx853sxQ==', NULL, NULL, NULL, 1, 'qwe123', 0, '00000000-0000-0000-0000-000000000000', '2022-03-16 09:16:41.804', '00000000-0000-0000-0000-000000000000', '2022-03-18 10:20:17.357', '0e3865c6-c9e7-11ec-a1af-002b67dcf564');
COMMIT;

-- ----------------------------
-- Table structure for biz_module
-- ----------------------------
DROP TABLE IF EXISTS "biz_module";
CREATE TABLE "biz_module" (
  "id" text(36) NOT NULL,
  "module_name" text(512) NOT NULL,
  "module_short_name" text(256) NOT NULL,
  "module_short_name_en" text(128) NOT NULL,
  "module_protocol" text(15) NOT NULL,
  "module_address" text(256) NOT NULL,
  "module_port" integer,
  "module_logo_address" text(512),
  "module_sso_address" text(512) NOT NULL,
  "module_todo_address" text(512),
  "serial_number" integer,
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id")
);

-- ----------------------------
-- Records of biz_module
-- ----------------------------
BEGIN;
INSERT INTO "biz_module" VALUES ('4a6798ec-0296-4516-9618-bd66cb77fa53', '一莎Admin开源项目平台', '一莎Admin', 'ys', 'http', '127.0.0.1', 8089, NULL, '/sso', '/todo', 2, '一莎Admin', 0, '00000000-0000-0000-0000-000000000000', '2022-02-07 10:26:44.670', '00000000-0000-0000-0000-000000000000', '2022-02-07 10:38:17.460', 'a46d2e6e-c9e6-11ec-a1af-002b67dcf564');
INSERT INTO "biz_module" VALUES ('81762d87-d4c5-483f-937f-4c0e77b534b5', '若依Admin开源项目平台', '若依Admin', 'ry', 'http', '127.0.0.1', 8086, NULL, '/sso', '/todo', 1, '若依Admin', 0, '00000000-0000-0000-0000-000000000000', '2022-02-07 10:22:22.53', '00000000-0000-0000-0000-000000000000', '2022-06-10 15:22:23.8829019', 'afd575c4-99ea-4922-86c5-99d6c483b10c');
INSERT INTO "biz_module" VALUES ('97b36999-a9b0-4033-bd06-7f54a03a6fd7', '若依Admin开源项目平台', '若依Admin', 'ry', 'http', '127.0.0.1', 8086, NULL, '/sso', '/todo', 1, NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-23 15:30:14.726', '00000000-0000-0000-0000-000000000000', '2022-02-23 15:32:19.412', 'a46d4bd4-c9e6-11ec-a1af-002b67dcf564');
COMMIT;

-- ----------------------------
-- Table structure for biz_user
-- ----------------------------
DROP TABLE IF EXISTS "biz_user";
CREATE TABLE "biz_user" (
  "id" text(36) NOT NULL,
  "user_logon_name" text(128) NOT NULL,
  "user_display_name" text(128) NOT NULL,
  "user_password" text(512) NOT NULL,
  "telephone" text(45),
  "mobilephone" text(45),
  "email" text(45),
  "is_enabled" integer NOT NULL,
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id")
);

-- ----------------------------
-- Records of biz_user
-- ----------------------------
BEGIN;
INSERT INTO "biz_user" VALUES ('225d9edb-1817-4890-8f3a-9c8f78eed3fe', 'ry_lisi1', '李四', 'kcAVKc+BvoWtRUcIwXZ72w==', '010-55558889', 13555556667, '456@abc.com', 1, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-17 15:52:24.800', '00000000-0000-0000-0000-000000000000', '2022-02-17 15:52:24.800', '0e3acbad-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user" VALUES ('441ca29e-0294-4ff5-92f4-df65a9996ee1', 'ry_zhangsan1', '张三', 'kcAVKc+BvoWtRUcIwXZ72w==', '010-55558888', 13555556666, '123@abc.com', 1, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-17 15:52:24.782', '00000000-0000-0000-0000-000000000000', '2022-02-17 15:52:24.782', '0e3ad5a3-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user" VALUES ('540b304d-6b23-4b60-9a58-27f4e8c437fc', 'ys_test', '伊莎测试', 'kcAVKc+BvoWtRUcIwXZ72w==', NULL, 13788889999, NULL, 1, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-09 16:29:28.351', '540b304d-6b23-4b60-9a58-27f4e8c437fc', '2022-05-01 23:38:47.326', '0e3ad73a-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user" VALUES ('79971bba-0c16-4df8-bd30-e732cda8ae58', 'ry_admin', '若以测试账号', 'kcAVKc+BvoWtRUcIwXZ72w==', NULL, NULL, NULL, 1, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-08 16:13:24.863', '00000000-0000-0000-0000-000000000000', '2022-06-10 15:22:42.0640683', 'b2aa82dc-b59c-4a6b-8472-4fce0e7139b1');
INSERT INTO "biz_user" VALUES ('8061f56f-03e1-4df6-b2ce-aface3b29871', 'ry_李四', '李四', 'kcAVKc+BvoWtRUcIwXZ72w==', '010-55558889', 13555556667, '456@abc.com', 1, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-17 15:46:33.942', '00000000-0000-0000-0000-000000000000', '2022-02-18 09:39:56.943', '0e3ad907-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user" VALUES ('a6e1a97b-772b-4a76-83a4-e55284c6daba', 'ry_zhangsan', '张三', 'kcAVKc+BvoWtRUcIwXZ72w==', '010-55558888', 13555556666, '123@abc.com', 1, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-17 15:46:33.922', '00000000-0000-0000-0000-000000000000', '2022-02-18 09:40:08.543', '0e3ad9f4-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user" VALUES ('e4994527-16de-4a2e-8d07-74a5a1f1ed3e', 'ry_test', '若以测试', 'kcAVKc+BvoWtRUcIwXZ72w==', '010-99987777', 13566666666, '23@qq.com', 1, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-08 16:41:01.720', '00000000-0000-0000-0000-000000000000', '2022-02-09 16:28:27.240', '0e3adac3-c9e7-11ec-a1af-002b67dcf564');
COMMIT;

-- ----------------------------
-- Table structure for biz_user_module
-- ----------------------------
DROP TABLE IF EXISTS "biz_user_module";
CREATE TABLE "biz_user_module" (
  "id" text(36) NOT NULL,
  "user_id" text(36) NOT NULL,
  "module_id" text(36) NOT NULL,
  "user_module_logon_name" text(128) NOT NULL,
  "user_module_password" text(512) NOT NULL,
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id"),
  CONSTRAINT "fk_um_mid" FOREIGN KEY ("module_id") REFERENCES "biz_module" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT "fk_um_uid" FOREIGN KEY ("user_id") REFERENCES "biz_user" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT
);

-- ----------------------------
-- Records of biz_user_module
-- ----------------------------
BEGIN;
INSERT INTO "biz_user_module" VALUES ('00f62dbf-da71-4e0b-868e-257eedf261b3', '79971bba-0c16-4df8-bd30-e732cda8ae58', '4a6798ec-0296-4516-9618-bd66cb77fa53', 'xx', 'xx', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 23:28:45.385', '00000000-0000-0000-0000-000000000000', '2022-05-01 23:28:45.385', '0e3bc50c-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user_module" VALUES ('2290effd-f427-45de-a0b6-06173e382f13', '8061f56f-03e1-4df6-b2ce-aface3b29871', '81762d87-d4c5-483f-937f-4c0e77b534b5', '李四', 'qwertyuiop!@#$6', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-17 15:46:33.950', '00000000-0000-0000-0000-000000000000', '2022-02-18 09:39:56.994', '0e3bd19b-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user_module" VALUES ('2daa327d-1de2-4fd9-b12b-f1e67aa56d0e', 'e4994527-16de-4a2e-8d07-74a5a1f1ed3e', '81762d87-d4c5-483f-937f-4c0e77b534b5', 'test', 'test1234', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-08 16:41:01.750', '00000000-0000-0000-0000-000000000000', '2022-02-09 16:28:27.256', '0e3bd3d8-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user_module" VALUES ('31ddfd44-e67a-4620-906d-23524fee803f', '540b304d-6b23-4b60-9a58-27f4e8c437fc', '81762d87-d4c5-483f-937f-4c0e77b534b5', 'test', 'test', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 13:46:18.829', '00000000-0000-0000-0000-000000000000', '2022-02-18 13:46:18.829', '0e3bd556-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user_module" VALUES ('4ca173b0-1c73-46a6-9874-070ca7694ec0', '225d9edb-1817-4890-8f3a-9c8f78eed3fe', '4a6798ec-0296-4516-9618-bd66cb77fa53', 'lisi1', 'lisi1lisi1lisi1', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-18 15:25:25.166', '00000000-0000-0000-0000-000000000000', '2022-02-22 09:24:36.947', '0e3bd6de-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user_module" VALUES ('5230f576-e558-4ef9-996a-dfcd91aca8cb', '441ca29e-0294-4ff5-92f4-df65a9996ee1', '81762d87-d4c5-483f-937f-4c0e77b534b5', 'zhangsan1', 'qwertyuiop!@#$5', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-17 15:52:24.793', '00000000-0000-0000-0000-000000000000', '2022-05-02 15:18:51.197', '1496f82a-278e-4da9-8329-5db04fdcbe1c');
INSERT INTO "biz_user_module" VALUES ('63c166bf-3a1a-4943-9ca6-f4e19dc69bbf', '441ca29e-0294-4ff5-92f4-df65a9996ee1', '81762d87-d4c5-483f-937f-4c0e77b534b5', 'dd', 'dd', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-03 09:50:24.059', '00000000-0000-0000-0000-000000000000', '2022-05-03 09:50:24.059', '4d8b8d06-bd47-4d7e-8087-3bf4f7fb8d29');
INSERT INTO "biz_user_module" VALUES ('74e45c5e-6f51-46bc-9911-5e338ad950b3', 'a6e1a97b-772b-4a76-83a4-e55284c6daba', '81762d87-d4c5-483f-937f-4c0e77b534b5', 'cc', 'cc', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 23:29:10.267', '00000000-0000-0000-0000-000000000000', '2022-05-01 23:29:10.267', '0e3bd9d6-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user_module" VALUES ('76379c9e-f837-4e1d-87f9-ba37336ff16a', '8061f56f-03e1-4df6-b2ce-aface3b29871', '4a6798ec-0296-4516-9618-bd66cb77fa53', 'C', 'C', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-02 15:19:13.807', '00000000-0000-0000-0000-000000000000', '2022-05-02 15:19:13.807', '0ec2789c-338d-4b61-b62b-66677d75af17');
INSERT INTO "biz_user_module" VALUES ('9cf1a024-ba9e-4b05-99e0-4842e37fcf36', '225d9edb-1817-4890-8f3a-9c8f78eed3fe', '4a6798ec-0296-4516-9618-bd66cb77fa53', 'lisi1', 'lisi1lisi1lisi1lisi1', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-18 09:38:53.455', '00000000-0000-0000-0000-000000000000', '2022-02-18 09:40:56.554', '0e3bdb48-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user_module" VALUES ('a19618d6-3ae5-44ec-82f4-27f354e28897', '441ca29e-0294-4ff5-92f4-df65a9996ee1', '4a6798ec-0296-4516-9618-bd66cb77fa53', 'qq', 'qq', NULL, 1, '45aeff89-2867-43e7-9b40-296233c069c5', '2022-02-24 14:16:54.715', '00000000-0000-0000-0000-000000000000', '2022-05-03 09:49:53.618', '646eca91-b6cd-4be0-81cf-d37940991f36');
INSERT INTO "biz_user_module" VALUES ('a8acba26-da7d-4fe4-be80-fba80af62992', '225d9edb-1817-4890-8f3a-9c8f78eed3fe', '81762d87-d4c5-483f-937f-4c0e77b534b5', 's', 's', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-02 15:19:37.741', '00000000-0000-0000-0000-000000000000', '2022-05-02 15:19:37.741', '5f056ff5-189c-45e4-803a-3e053ee102fe');
INSERT INTO "biz_user_module" VALUES ('ad430034-bc8f-4e87-aeb1-68c1ef780864', '540b304d-6b23-4b60-9a58-27f4e8c437fc', '4a6798ec-0296-4516-9618-bd66cb77fa53', 'test', 'test1234', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-09 16:29:28.365', '00000000-0000-0000-0000-000000000000', '2022-02-09 16:29:28.365', '0e3bde2a-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user_module" VALUES ('bb643c2c-198e-41b4-944c-f31d0ee5d2af', 'a6e1a97b-772b-4a76-83a4-e55284c6daba', '81762d87-d4c5-483f-937f-4c0e77b534b5', 'zhangsan', 'qwertyuiop!@#$5', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-17 15:46:33.935', '00000000-0000-0000-0000-000000000000', '2022-02-22 09:24:50.603', '0e3bdf7a-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user_module" VALUES ('d2245564-6e43-4aad-8dd7-aac2db983cca', '225d9edb-1817-4890-8f3a-9c8f78eed3fe', '81762d87-d4c5-483f-937f-4c0e77b534b5', 'lisi1', 'lisi1lisi1lisi1', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-18 15:25:55.445', '00000000-0000-0000-0000-000000000000', '2022-02-22 09:24:32.101', '0e3be0d3-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user_module" VALUES ('da0b6394-e193-46df-89f7-5941e17740dc', '225d9edb-1817-4890-8f3a-9c8f78eed3fe', '81762d87-d4c5-483f-937f-4c0e77b534b5', 'lisi1', 'lisi1lisi1', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-18 15:22:15.450', '00000000-0000-0000-0000-000000000000', '2022-02-18 15:24:59.801', '0e3be299-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user_module" VALUES ('eed681b9-aed5-4431-899d-de5b2043ac93', '225d9edb-1817-4890-8f3a-9c8f78eed3fe', '81762d87-d4c5-483f-937f-4c0e77b534b5', 'lisi1', 'qwertyuiop!@#$6', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-17 15:52:24.807', '00000000-0000-0000-0000-000000000000', '2022-02-18 09:40:37.404', '0e3be409-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "biz_user_module" VALUES ('fdb6eaae-12f7-4fa6-991b-ae1727b44f7a', '79971bba-0c16-4df8-bd30-e732cda8ae58', '81762d87-d4c5-483f-937f-4c0e77b534b5', 'admin', 'kcAVKc+BvoWtRUcIwXZ72w==', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-08 16:13:24.875', '00000000-0000-0000-0000-000000000000', '2022-06-10 15:22:42.0831659', '56506946-4c15-452d-9ba0-fde29fd7017f');
COMMIT;

-- ----------------------------
-- Table structure for sys_code_table
-- ----------------------------
DROP TABLE IF EXISTS "sys_code_table";
CREATE TABLE "sys_code_table" (
  "id" text(36) NOT NULL,
  "code_name" text(128) NOT NULL,
  "code" text(128) NOT NULL,
  "value" text(256),
  "parent_id" text(36),
  "remark" text(512),
  "serial_number" integer,
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id")
);

-- ----------------------------
-- Records of sys_code_table
-- ----------------------------
BEGIN;
INSERT INTO "sys_code_table" VALUES ('221c849a-4943-458c-86f4-d301996228cc', '第三性别', 'SexOther', 2, '5c6adfba-855d-436b-bb31-cdb2b8c77e66', '第三性别', 2, 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 11:56:12.000', '00000000-0000-0000-0000-000000000000', '2021-12-03 15:48:22.525', '0e3cd714-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_code_table" VALUES ('342e0919-3116-466e-8665-042fb4543df7', '是否判断', 'YesOrNo', '', NULL, '是否判断', 1, 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 11:28:14.000', '00000000-0000-0000-0000-000000000000', '2022-04-20 10:55:29.033', '0e3cdf85-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_code_table" VALUES ('3ea32b1c-a94c-4524-833d-2b21bf97feb6', '纪委书记', 'JWSJ', 'JWSJ', 'a2a26c79-9483-4204-b209-d3b3c53b989b', '纪委书记', 1, 0, '00000000-0000-0000-0000-000000000000', '2021-12-20 13:57:50.671', '00000000-0000-0000-0000-000000000000', '2021-12-20 13:57:50.671', '0e3ce0b7-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_code_table" VALUES ('5ba22c2c-cd8c-4a43-a88a-a3a721756f4b', '女', 'Female', 1, '5c6adfba-855d-436b-bb31-cdb2b8c77e66', '女', 1, 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 11:55:45.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 11:59:05.000', '0e3ce19f-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_code_table" VALUES ('5c6adfba-855d-436b-bb31-cdb2b8c77e66', '性别', 'Sex', NULL, NULL, '性别', 2, 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 11:28:38.000', '00000000-0000-0000-0000-000000000000', '2022-04-28 14:38:56.585', '0e3ce265-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_code_table" VALUES ('6e175e30-67a7-4d7d-9d67-fd9e4e7c47d7', '经理', 'JL', 'JL', 'a2a26c79-9483-4204-b209-d3b3c53b989b', '经理', 3, 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 14:43:59.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 14:43:59.000', '0e3ce336-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_code_table" VALUES ('6f0e90ff-4b15-4d17-8939-9523c83b3e80', '普通员工', 'YG', 'YG', 'a2a26c79-9483-4204-b209-d3b3c53b989b', '普通员工', 4, 0, '00000000-0000-0000-0000-000000000000', '2021-12-03 15:47:21.767', '00000000-0000-0000-0000-000000000000', '2021-12-03 16:25:32.205', '0e3ce459-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_code_table" VALUES ('7f6223be-740f-466d-9327-46405dfa9022', '男', 'Male', 0, '5c6adfba-855d-436b-bb31-cdb2b8c77e66', '男', 0, 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 11:55:25.000', '00000000-0000-0000-0000-000000000000', '2021-04-29 15:30:01.000', '0e3ce52c-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_code_table" VALUES ('918a2974-6a77-444f-b5a6-039f01a77a88', '董事长', 'DSZ', 'DSZ', 'a2a26c79-9483-4204-b209-d3b3c53b989b', '董事长', 0, 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 14:42:53.000', '00000000-0000-0000-0000-000000000000', '2021-12-20 13:55:05.157', '0e3ce5f3-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_code_table" VALUES ('9847eaa8-12fc-48cd-84ce-8dca31a7b813', '书记', 'SJ', 'SJ', 'a2a26c79-9483-4204-b209-d3b3c53b989b', '书记', 1, 0, '00000000-0000-0000-0000-000000000000', '2021-12-20 13:48:01.013', '00000000-0000-0000-0000-000000000000', '2021-12-20 13:55:08.878', '0e3ce6ab-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_code_table" VALUES ('a2a26c79-9483-4204-b209-d3b3c53b989b', '岗位', 'Position', NULL, NULL, '岗位', 3, 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 14:29:07', '00000000-0000-0000-0000-000000000000', '2022-06-10 15:21:12.8190844', '2c2d4fcb-3bb0-4791-8d76-86501bb5d4fc');
INSERT INTO "sys_code_table" VALUES ('c4435185-6779-452f-85ae-14b1251a2920', '总经理', 'ZJL', 'ZJL', 'a2a26c79-9483-4204-b209-d3b3c53b989b', '总经理', 2, 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 14:43:20.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 14:44:09.000', '0e3ce828-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_code_table" VALUES ('dc7a3882-fb25-4ba9-a30b-f9256f58e9c0', '是', 'Yes', 1, '342e0919-3116-466e-8665-042fb4543df7', '是', 0, 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 12:00:03.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 12:00:03.000', '0e3ce8dd-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_code_table" VALUES ('dd12c0c2-768e-42da-b47f-8b386e591cae', '否', 'No', 0, '342e0919-3116-466e-8665-042fb4543df7', '否', 1, 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 12:00:48.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 12:00:48.000', '0e3ce99a-c9e7-11ec-a1af-002b67dcf564');
COMMIT;

-- ----------------------------
-- Table structure for sys_import_config
-- ----------------------------
DROP TABLE IF EXISTS "sys_import_config";
CREATE TABLE "sys_import_config" (
  "id" text(36) NOT NULL,
  "config_name" text(128) NOT NULL,
  "start_row" integer NOT NULL,
  "start_column" integer NOT NULL,
  "worksheet_indexes" text(512),
  "serial_number" integer,
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id")
);

-- ----------------------------
-- Records of sys_import_config
-- ----------------------------
BEGIN;
INSERT INTO "sys_import_config" VALUES ('21a45ec5-0758-4ad4-ad5a-31f9cf635f61', 'BizUserImportConfig', 1, 1, NULL, 3, '业务用户导入配置', 0, '00000000-0000-0000-0000-000000000000', '2022-02-16 10:06:30.641', '00000000-0000-0000-0000-000000000000', '2022-04-25 16:22:37.570', '0e3ddd97-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config" VALUES ('51510173-0253-48a8-bdcb-4cb4827c5d08', 'RoleImportConfig', 1, 1, NULL, 2, '角色导入配置', 0, '00000000-0000-0000-0000-000000000000', '2021-05-07 14:36:28.000', '00000000-0000-0000-0000-000000000000', '2022-02-08 15:49:05.533', '0e3de6ed-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config" VALUES ('ba6070b3-a815-4efb-ac1f-c804502544cf', 'CommonConfigTest', 2, 1, '', 1, '综合常规性校验', 0, '00000000-0000-0000-0000-000000000000', '2021-04-29 16:11:34.000', '00000000-0000-0000-0000-000000000000', '2022-04-08 17:28:23.914', '0e3de812-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config" VALUES ('e28c1ee6-1c16-405f-ac6c-a83c5923ea32', 'UserImportConfig', 1, 1, NULL, 4, '系统用户导入配置', 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 10:48:36.916', '00000000-0000-0000-0000-000000000000', '2022-06-10 15:21:36.9104751', '38332b59-9aca-4097-b8c3-cfc64f7bf0f5');
COMMIT;

-- ----------------------------
-- Table structure for sys_import_config_detail
-- ----------------------------
DROP TABLE IF EXISTS "sys_import_config_detail";
CREATE TABLE "sys_import_config_detail" (
  "id" text(36) NOT NULL,
  "parent_id" text(36) NOT NULL,
  "data_type" integer NOT NULL,
  "cells" text(512) NOT NULL,
  "required" integer,
  "max_value" real,
  "min_value" real,
  "decimal_limit" integer,
  "text_enum" text(1024),
  "extend1" text(64),
  "extend2" text(128),
  "extend3" text(256),
  "serial_number" integer,
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id"),
  CONSTRAINT "icdpid" FOREIGN KEY ("parent_id") REFERENCES "sys_import_config" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT
);

-- ----------------------------
-- Records of sys_import_config_detail
-- ----------------------------
BEGIN;
INSERT INTO "sys_import_config_detail" VALUES ('01ee9cc0-da0b-4635-8704-c0c42e1bcd23', '21a45ec5-0758-4ad4-ad5a-31f9cf635f61', 2, 5, NULL, NULL, NULL, NULL, NULL, '^(\d{3,4}-)?\d{6,8}$', NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-16 11:07:43.514', '00000000-0000-0000-0000-000000000000', '2022-02-17 16:53:41.252', '0e3ed3ff-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('14eaa1cd-effc-494f-b6dc-261964852cb9', 'e28c1ee6-1c16-405f-ac6c-a83c5923ea32', 2, '1,2', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 10:49:27.678', '00000000-0000-0000-0000-000000000000', '2022-02-18 10:49:27.678', '0e3ede42-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('211b1c6a-91ac-4c60-8061-183d939e8b94', 'ba6070b3-a815-4efb-ac1f-c804502544cf', 0, 6, 0, 100.0, 0.0, 2, NULL, NULL, NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-05-12 13:53:52.000', '00000000-0000-0000-0000-000000000000', '2021-05-13 10:02:36.000', '0e3edf9d-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('3cc6c7ea-1ee2-4885-ae1a-c9eb1ff12b89', '51510173-0253-48a8-bdcb-4cb4827c5d08', 2, 1, 1, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-09-23 14:12:48.000', '00000000-0000-0000-0000-000000000000', '2021-09-23 15:24:17.000', '0e3ee13e-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('4dc94136-4f5c-42ef-baab-a73cd49160fc', 'ba6070b3-a815-4efb-ac1f-c804502544cf', 4, 10, 0, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-05-12 13:54:35.000', '00000000-0000-0000-0000-000000000000', '2021-05-12 13:54:35.000', '0e3ee23f-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('53d65856-21a4-40ec-98c1-6a85b5603e22', 'ba6070b3-a815-4efb-ac1f-c804502544cf', 3, 4, 1, 33.0, 1.0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-05-05 09:08:18.000', '00000000-0000-0000-0000-000000000000', '2021-05-12 13:53:15.000', '0e3ee33e-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('59e91b35-be43-4fe1-baa7-9c602b93833a', '21a45ec5-0758-4ad4-ad5a-31f9cf635f61', 2, 4, NULL, NULL, NULL, NULL, NULL, '^1\d{10}$', NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-16 10:50:15.255', '00000000-0000-0000-0000-000000000000', '2022-02-18 10:49:43.687', '0e3ee442-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('721369f5-5f89-47e4-9b1e-dfd8a7795a41', 'ba6070b3-a815-4efb-ac1f-c804502544cf', 0, 1, 1, 100.0, 0.0, 2, NULL, NULL, NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-05-05 09:00:56.000', '00000000-0000-0000-0000-000000000000', '2021-05-13 10:02:46.000', '0e3ee536-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('762ae51f-b973-49d2-8fcc-502aa28ec978', 'e28c1ee6-1c16-405f-ac6c-a83c5923ea32', 2, 5, NULL, NULL, NULL, NULL, NULL, '^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$', NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 10:51:17.644', '00000000-0000-0000-0000-000000000000', '2022-04-13 16:28:17.235', '0e3ee62e-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('881d73b4-394a-4e49-a985-0c6fa6a59a95', 'ba6070b3-a815-4efb-ac1f-c804502544cf', 3, 9, 0, 0.0, 0.0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-05-12 13:54:27.000', '00000000-0000-0000-0000-000000000000', '2021-05-13 10:02:25.000', '0e3ee722-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('9c67a664-66c7-4d39-bda8-2f9b074cb0ab', 'ba6070b3-a815-4efb-ac1f-c804502544cf', 1, 7, 0, 100.0, 0.0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-05-12 13:54:09.000', '00000000-0000-0000-0000-000000000000', '2021-05-13 10:02:32.000', '0e3ee814-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('a0177782-ee2c-4017-ac7c-a09ab50e7b12', '21a45ec5-0758-4ad4-ad5a-31f9cf635f61', 2, 6, NULL, NULL, NULL, NULL, NULL, '^\w+([-+.]\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$', NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-16 11:09:40.739', '00000000-0000-0000-0000-000000000000', '2022-02-17 16:57:26.192', '0e3ee8f9-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('abc36e6e-ae05-41b1-86a4-e09981e05578', 'ba6070b3-a815-4efb-ac1f-c804502544cf', 2, 3, 1, NULL, NULL, 0, '男,女', NULL, NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-05-05 09:06:36.000', '00000000-0000-0000-0000-000000000000', '2021-12-24 09:28:17.209', '0e3ee9da-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('c107b3c5-4713-4f9f-8b0f-198d7ffe3a6f', '51510173-0253-48a8-bdcb-4cb4827c5d08', 1, 2, NULL, NULL, NULL, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-09-23 14:13:00.000', '00000000-0000-0000-0000-000000000000', '2022-02-08 15:50:03.045', '0e3eeac4-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('c351de82-9888-4e8c-82ca-16dfd9cfe721', 'ba6070b3-a815-4efb-ac1f-c804502544cf', 1, 2, 1, 100.0, 0.0, 0, '', NULL, NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-05-05 08:53:20.000', '00000000-0000-0000-0000-000000000000', '2021-05-12 16:19:50.000', '0e3eebba-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('c4c349d5-8e82-4e2d-8d5f-36b2535de492', 'ba6070b3-a815-4efb-ac1f-c804502544cf', 2, 8, 0, 0.0, 0.0, 0, '男,女', NULL, NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-05-12 13:54:18.000', '00000000-0000-0000-0000-000000000000', '2021-06-11 14:14:07.000', '0e3eecb1-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('d405b74e-d52a-4f9e-b806-1c1d0bcaba40', 'e28c1ee6-1c16-405f-ac6c-a83c5923ea32', 2, 4, NULL, NULL, NULL, NULL, NULL, '^(\d{3,4}-)?\d{6,8}$', NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 10:50:44.888', '00000000-0000-0000-0000-000000000000', '2022-05-02 15:17:45.980', '8d9d5bb5-f6c2-4e69-b4ec-a57dbf8f2f79');
INSERT INTO "sys_import_config_detail" VALUES ('e8a1a290-169a-4c9a-bed8-fffff884c1f0', 'e28c1ee6-1c16-405f-ac6c-a83c5923ea32', 2, 3, NULL, NULL, NULL, NULL, '', '^1\d{10}$', NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 10:50:17.615', '00000000-0000-0000-0000-000000000000', '2022-05-02 15:17:50.160', '6e8aa94c-1e57-4ffd-9e80-72e1125156f6');
INSERT INTO "sys_import_config_detail" VALUES ('f14059ba-a95c-4b1f-881f-86eea84944f6', 'ba6070b3-a815-4efb-ac1f-c804502544cf', 4, 5, 1, 90.0, 1.0, 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-05-05 09:08:35.000', '00000000-0000-0000-0000-000000000000', '2021-05-12 13:53:27.000', '0e3eefe0-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_import_config_detail" VALUES ('f6e4400e-d695-406c-ae1d-853e59c8d75a', '21a45ec5-0758-4ad4-ad5a-31f9cf635f61', 2, '1,2,3', 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-16 10:08:39.650', '00000000-0000-0000-0000-000000000000', '2022-02-16 10:10:11.277', '0e3ef13c-c9e7-11ec-a1af-002b67dcf564');
COMMIT;

-- ----------------------------
-- Table structure for sys_language
-- ----------------------------
DROP TABLE IF EXISTS "sys_language";
CREATE TABLE "sys_language" (
  "id" text(36) NOT NULL,
  "language_name" text(45) NOT NULL,
  "order_number" integer,
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id")
);

-- ----------------------------
-- Records of sys_language
-- ----------------------------
BEGIN;
INSERT INTO "sys_language" VALUES ('8223B5C4-C55A-4F02-98D2-BA7F320B0EA7', 'ru-RU', 2, '俄国-俄国', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 11:56:12.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 11:56:12.000', '0e3fef76-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_language" VALUES ('8306A39F-BFBD-430F-8315-15B6EBE3861D', 'en-US', 1, '英国-美国', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 11:56:12.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 11:56:12.000', '0e3ff849-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_language" VALUES ('9F06E722-5994-40F3-8BED-FE65C207E4D5', 'zh-CN', 0, '华-中国', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 11:56:12.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 11:56:12.000', '0e3ff930-c9e7-11ec-a1af-002b67dcf564');
COMMIT;

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS "sys_log";
CREATE TABLE "sys_log" (
  "id" text(36) NOT NULL,
  "user_id" text(36) NOT NULL,
  "user_name" text(128) NOT NULL,
  "org_id" text(36) NOT NULL,
  "org_name" text(128) NOT NULL,
  "system" text(128),
  "browser" text(128),
  "ip" text(45) NOT NULL,
  "operation_type" integer NOT NULL,
  "request_method" text(20) NOT NULL,
  "request_url" text(512) NOT NULL,
  "params" text(1024),
  "result" blob,
  "old_value" blob,
  "new_value" blob,
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id")
);

-- ----------------------------
-- Records of sys_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS "sys_menu";
CREATE TABLE "sys_menu" (
  "id" text(36) NOT NULL,
  "path" text(256),
  "menu_name" text(128) NOT NULL,
  "menu_url" text(256),
  "parent_id" text(36),
  "serial_number" integer,
  "menu_type" integer NOT NULL,
  "icon" text(256),
  "code" text(125),
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id")
);

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO "sys_menu" VALUES ('00d356a5-f24b-4fe9-8616-aa8d36c37be8', NULL, '暂停任务', NULL, '328734a7-3aab-424d-8fb5-101a30335e3c', 5, 1, NULL, 'schedule:job:pause', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-08-24 14:45:05.000', '00000000-0000-0000-0000-000000000000', '2021-08-24 14:45:05.000', '326589c1-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('03237dc0-d26f-4611-8fe1-ba08ac1da7d8', '/businessModule', '离态用户管理', '/BizUserNonModule', 'cc21d837-43ed-49c1-bc5f-9bb647c1fd14', 3, 0, 'list', NULL, '离态用户管理', 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 15:09:22.408', '00000000-0000-0000-0000-000000000000', '2022-02-18 15:09:22.408', '32659529-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('0745a4ca-fb04-48d0-8ac5-7114acd15deb', NULL, '编辑同步账号', NULL, '1bb376e1-c420-4bd4-ab39-75f569095ea4', 3, 1, NULL, 'account:edit:entity', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-03-15 09:09:31.572', '00000000-0000-0000-0000-000000000000', '2022-03-15 09:09:31.572', '326595e8-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('0d12b992-92df-4961-a50b-a2aac55da1e2', NULL, '查询列表', NULL, '9321de30-10c8-4709-aff3-bba47312693f', 1, 2, NULL, 'log:query:list', '查询列表', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:33:41.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 18:33:41.000', '32659671-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('0e989075-01cd-4c6e-a622-d336106bf255', NULL, '新增角色', NULL, 'c80f26ab-b2bc-4766-a40e-17ed9417a5c7', 2, 1, NULL, 'role:add:entity', '新增角色', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:17:12.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 18:17:12.000', '32659769-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('0f43194b-df86-4370-aeeb-26811cfab50c', NULL, '删除菜单', NULL, 'cf7929b6-f9d9-4100-85f9-f63582583a61', 4, 1, NULL, 'menu:del:entities', '删除菜单', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:07:09.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 18:07:09.000', '326597e6-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('13e73c0d-a285-43af-9167-eef89381d08e', NULL, '新增字典', NULL, 'a27a2518-53d8-4ed2-9655-3e1781d615dd', 2, 1, NULL, 'code:add:entity', '新增字典', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:25:32.000', '00000000-0000-0000-0000-000000000000', '2021-12-18 20:26:46.285', '32659858-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('1553af7d-5749-4894-8c3e-84cb3cf2f2dd', NULL, '删除业务用户', NULL, 'ef3148eb-ebe6-4d9a-8806-aa783570290b', 4, 1, NULL, 'user:module:del', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-07 16:24:16.373', '00000000-0000-0000-0000-000000000000', '2022-02-16 10:03:38.275', '326598d8-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('18cd9b4c-bfbd-442b-86dc-11eee193d886', NULL, '分配权限', NULL, 'c80f26ab-b2bc-4766-a40e-17ed9417a5c7', 6, 1, NULL, 'role:grant:permission', '分配权限', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 21:57:41.000', '00000000-0000-0000-0000-000000000000', '2021-04-12 19:18:31.000', '32659946-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('1bb376e1-c420-4bd4-ab39-75f569095ea4', '/businessModule', '同步账号管理', '/BizAccount', 'cc21d837-43ed-49c1-bc5f-9bb647c1fd14', 4, 0, 'list', NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-03-15 09:07:20.130', '00000000-0000-0000-0000-000000000000', '2022-03-15 09:07:20.130', '326599b7-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('206bb7dc-101a-4d76-89fc-606cdd247355', NULL, '查询用户列表', NULL, '03237dc0-d26f-4611-8fe1-ba08ac1da7d8', 1, 2, NULL, 'user:nonmodule:list', '查询用户列表', 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 15:10:38.434', '00000000-0000-0000-0000-000000000000', '2022-05-03 09:45:11.718', '45bfcbca-c28f-4fa5-9809-a1e454bb41f2');
INSERT INTO "sys_menu" VALUES ('21c94e72-6dde-40c0-bae8-c0ef0a1c476c', NULL, '编辑配置', NULL, '63f294fb-eea5-41cf-8343-b43d60fdd680', 3, 1, NULL, 'import:config:edit:entity', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-04-29 15:16:17.000', '00000000-0000-0000-0000-000000000000', '2021-04-29 15:16:17.000', '32659a9a-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('2634a816-5dd9-4bfd-a573-f6b0020204db', NULL, '编辑字典', NULL, 'a27a2518-53d8-4ed2-9655-3e1781d615dd', 3, 1, NULL, 'code:edit:entity', '编辑字典', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:26:15.000', '00000000-0000-0000-0000-000000000000', '2021-12-18 20:26:55.688', '32659b15-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('26d0ed04-5670-4707-ad91-e2893edca2ed', NULL, '删除机构', NULL, 'b0652b6e-51ee-49ff-88b9-019bc8378f0b', 4, 1, NULL, 'org:del:entities', '删除机构', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 17:57:09.000', '00000000-0000-0000-0000-000000000000', '2022-04-28 16:38:59.078', '32659b86-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('2923ffda-b4dc-4d92-9451-59a977a7edcb', NULL, '查询实体', NULL, '9321de30-10c8-4709-aff3-bba47312693f', 2, 1, NULL, 'log:query:entity', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-04-13 16:41:09.000', '00000000-0000-0000-0000-000000000000', '2021-04-13 16:41:13.000', '32659bf2-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('300a8888-11af-4272-a638-baefc8e7858d', NULL, '删除同步账号', NULL, '1bb376e1-c420-4bd4-ab39-75f569095ea4', 4, 1, NULL, 'account:del:entities', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-03-15 09:10:01.527', '00000000-0000-0000-0000-000000000000', '2022-03-15 09:10:01.527', '32659cb5-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('328734a7-3aab-424d-8fb5-101a30335e3c', '/system', '任务调度', '/ScheduleJobManagement', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', 9, 0, 'form', NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-08-24 14:41:51.000', '00000000-0000-0000-0000-000000000000', '2021-08-24 14:46:32.000', '32659d37-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('371362df-0b05-4eee-9930-9288b6c8cc45', NULL, '删除用户', NULL, 'e2363d77-45aa-4be1-b878-48d31aed728b', 4, 1, NULL, 'user:del:entities', '删除用户', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:02:15.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 18:02:15.000', '32659da6-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('45c8b9cf-5ac2-4e42-9cc8-051871a1d63f', NULL, '查询列表', NULL, 'b0652b6e-51ee-49ff-88b9-019bc8378f0b', 1, 2, NULL, 'org:query:list', '查询列表', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 17:51:13.000', '00000000-0000-0000-0000-000000000000', '2022-05-02 15:16:34.045', '163b2bd3-4336-4b72-ae2d-9c91985b3cdc');
INSERT INTO "sys_menu" VALUES ('45e0f73e-4c77-4719-b76d-482de9a0afa6', NULL, '新增配置', NULL, '63f294fb-eea5-41cf-8343-b43d60fdd680', 2, 1, NULL, 'import:config:add:entity', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-04-29 15:15:50.000', '00000000-0000-0000-0000-000000000000', '2021-04-29 15:15:50.000', '32659e83-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('4c4126b1-8c20-44a5-a2cf-9ea19e582af9', NULL, '数据导出', NULL, 'c80f26ab-b2bc-4766-a40e-17ed9417a5c7', 8, 1, NULL, 'role:list:export', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-04-28 18:04:02.000', '00000000-0000-0000-0000-000000000000', '2021-04-28 18:04:02.000', '32659eef-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('4ef0101a-9911-47d0-8555-841ce928903f', NULL, '编辑用户', NULL, 'e2363d77-45aa-4be1-b878-48d31aed728b', 3, 1, NULL, 'user:edit:entity', '编辑用户', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:01:32.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 18:01:32.000', '32659f5f-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('5be9a12e-1c91-40bb-be8e-3f38da256c19', NULL, '编辑菜单', NULL, 'cf7929b6-f9d9-4100-85f9-f63582583a61', 3, 1, NULL, 'menu:edit:entity', '编辑菜单', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:06:33.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 18:06:33.000', '32659fcd-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('60f51a50-7fb8-47df-bbee-20a4bb29d650', NULL, '编辑角色', NULL, 'c80f26ab-b2bc-4766-a40e-17ed9417a5c7', 3, 1, NULL, 'role:edit:entity', '编辑角色', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:17:47.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 18:17:47.000', '3265a041-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('63f294fb-eea5-41cf-8343-b43d60fdd680', '/system', '导入配置', '/ImportConfigManagement', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', 7, 0, 'form', NULL, '导入配置', 0, '00000000-0000-0000-0000-000000000000', '2021-04-29 15:10:12.000', '00000000-0000-0000-0000-000000000000', '2021-04-29 16:51:36.000', '3265a0af-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('66469b10-a974-4abf-bd72-b7a205a09b47', NULL, '删除模块', NULL, 'a81bb7aa-d7c2-41b9-b616-b46d3d7d2cf3', 4, 1, NULL, 'module:del:entity', '删除模块', 0, '00000000-0000-0000-0000-000000000000', '2022-01-26 15:16:40.206', '00000000-0000-0000-0000-000000000000', '2022-01-26 16:49:43.518', '3265a116-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('66d87039-4811-4ba8-87b4-e53ed0daf21f', NULL, '查询同步账号', NULL, '1bb376e1-c420-4bd4-ab39-75f569095ea4', 1, 2, NULL, 'account:query:list', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-03-15 09:08:26.201', '00000000-0000-0000-0000-000000000000', '2022-04-21 10:09:49.537', '3265a189-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('78c1335e-f05a-4431-a85b-cee182b446f3', NULL, '新增业务用户', NULL, 'ef3148eb-ebe6-4d9a-8806-aa783570290b', 2, 1, NULL, 'user:module:add', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-07 16:22:56.673', '00000000-0000-0000-0000-000000000000', '2022-02-16 10:03:20.885', '3265a1f8-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('7ffd51d8-3475-4b82-a0e7-bd5e92e5f174', NULL, '新增同步账号', NULL, '1bb376e1-c420-4bd4-ab39-75f569095ea4', 2, 1, NULL, 'account:add:entity', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-03-15 09:08:56.161', '00000000-0000-0000-0000-000000000000', '2022-03-15 09:08:56.161', '3265a267-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('8169ab55-b24e-45b5-99f1-9d65d55af215', NULL, '查询列表', NULL, 'a81bb7aa-d7c2-41b9-b616-b46d3d7d2cf3', 1, 2, NULL, 'biz:module:list', '查询列表', 0, '00000000-0000-0000-0000-000000000000', '2022-01-26 15:14:32.994', '00000000-0000-0000-0000-000000000000', '2022-04-21 10:09:27.357', '3265a2d2-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('837a330f-11bd-4a70-93b5-25af2c905408', NULL, '关联菜单', NULL, 'c80f26ab-b2bc-4766-a40e-17ed9417a5c7', 5, 1, NULL, 'role:relate:menus', '关联菜单', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 21:59:03.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 21:59:03.000', '3265a35d-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('8d549066-fe5d-466c-b540-3525ebf30def', NULL, '新增机构', NULL, 'b0652b6e-51ee-49ff-88b9-019bc8378f0b', 2, 1, NULL, 'org:add:entity', '新增机构', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 17:55:41.000', '00000000-0000-0000-0000-000000000000', '2022-04-29 13:52:06.549', '3265a442-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('8ef1c60e-d626-4a01-9bb2-8e609c0b40fc', NULL, '启动任务', NULL, '328734a7-3aab-424d-8fb5-101a30335e3c', 4, 1, NULL, 'schedule:job:add', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-08-24 14:44:40.000', '00000000-0000-0000-0000-000000000000', '2021-08-24 14:44:40.000', '3265a4c6-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('8ff6bcd2-8701-4f45-aea2-bbc78718c4fb', NULL, '恢复任务', NULL, '328734a7-3aab-424d-8fb5-101a30335e3c', 6, 1, NULL, 'schedule:job:resume', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-08-24 14:45:34.000', '00000000-0000-0000-0000-000000000000', '2021-08-24 14:53:34.000', '3265a533-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('9321de30-10c8-4709-aff3-bba47312693f', '/system', '审计日志', '/LogManagement', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', 6, 0, 'documentation', NULL, '审计日志管理菜单', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 16:12:40.000', '00000000-0000-0000-0000-000000000000', '2021-04-29 15:17:23.000', '3265a5a3-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('a27a2518-53d8-4ed2-9655-3e1781d615dd', '/system', '数据字典', '/CodeTableManagement', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', 5, 0, 'table', NULL, '数据字典管理菜单', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 16:11:47.000', '00000000-0000-0000-0000-000000000000', '2021-04-29 15:17:19.000', '3265a610-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('a4416f30-7381-48d2-a074-b2e9a9481c3c', NULL, '数据导入', NULL, 'c80f26ab-b2bc-4766-a40e-17ed9417a5c7', 9, 1, NULL, 'role:list:import', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-05-07 10:29:59.000', '00000000-0000-0000-0000-000000000000', '2021-05-07 10:29:59.000', '3265a678-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('a4a59f63-f397-4850-ac4a-b06b41acfc34', NULL, '权限下放', NULL, 'c80f26ab-b2bc-4766-a40e-17ed9417a5c7', 7, 1, NULL, 'role:delegate:permission', '权限下放', 0, '00000000-0000-0000-0000-000000000000', '2021-11-11 14:27:50.000', '00000000-0000-0000-0000-000000000000', '2021-11-11 14:27:50.000', '3265a6e7-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('a63b6939-563f-41a2-b526-525560069e3b', NULL, '查询列表', NULL, '328734a7-3aab-424d-8fb5-101a30335e3c', 0, 2, NULL, 'job:query:list', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-08-24 14:42:36.000', '00000000-0000-0000-0000-000000000000', '2022-04-21 10:08:44.371', '3265a755-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('a81bb7aa-d7c2-41b9-b616-b46d3d7d2cf3', '/businessModule', '模块管理', '/BizModule', 'cc21d837-43ed-49c1-bc5f-9bb647c1fd14', 1, 0, 'list', NULL, '模块管理', 0, '00000000-0000-0000-0000-000000000000', '2022-01-26 15:12:57.158', '00000000-0000-0000-0000-000000000000', '2022-01-26 17:29:54.882', '3265a827-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('aa0a8b78-5e35-46f5-be7e-2a55f20f6470', '/system', '系统管理', '', NULL, 1, 0, 'tree', NULL, '系统管理目录', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 15:44:23.000', '00000000-0000-0000-0000-000000000000', '2021-06-11 14:12:01.000', '3265a898-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('af62fa5d-4808-4a59-9297-58b0df442fff', NULL, '新增模块', NULL, 'a81bb7aa-d7c2-41b9-b616-b46d3d7d2cf3', 2, 1, NULL, 'module:add:entity', '新增模块', 0, '00000000-0000-0000-0000-000000000000', '2022-01-26 15:15:13.683', '00000000-0000-0000-0000-000000000000', '2022-01-26 16:49:55.245', '3265a8fe-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('b0652b6e-51ee-49ff-88b9-019bc8378f0b', '/system', '机构管理', '/OrganizationManagement', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', 1, 0, 'tree-table', '', '机构管理', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 16:05:25', '00000000-0000-0000-0000-000000000000', '2022-06-10 15:20:35.0565393', '2b0d02ba-85da-4b05-9443-01b68050cce6');
INSERT INTO "sys_menu" VALUES ('b25958ea-608d-436f-8e01-b8fcc101905d', '/system', '多语管理', '/LanguageManagement', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', 10, 0, 'form', NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-08-05 11:20:24.000', '00000000-0000-0000-0000-000000000000', '2021-08-24 14:41:20.000', '3265a9d8-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('b3b8f210-c86e-422c-8434-6d9e13bcbaba', NULL, '查询信息', NULL, 'f34914ab-50f3-4acf-b844-9cfc70834896', 1, 2, NULL, 'query:hardware:info', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-12-10 16:38:41.703', '00000000-0000-0000-0000-000000000000', '2022-04-21 10:09:01.773', '3265aa62-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('b807f782-8b8c-49b6-a62d-e230dd44cd7e', NULL, '删除角色', NULL, 'c80f26ab-b2bc-4766-a40e-17ed9417a5c7', 4, 1, NULL, 'role:del:entities', '删除角色', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:18:23.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 18:18:23.000', '3265aad4-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('be4b8341-f1a7-473b-bad7-5b4b41732e49', '/system', '在线管理', '/OnlineUserManagement', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', 8, 0, 'form', NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-06-09 15:16:25.000', '00000000-0000-0000-0000-000000000000', '2021-06-09 15:18:22.000', '3265ab41-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('bec177ff-23ce-449f-ade4-dd0e62142842', NULL, '编辑机构', NULL, 'b0652b6e-51ee-49ff-88b9-019bc8378f0b', 3, 1, NULL, 'org:edit:entity', '编辑机构', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 17:56:36.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 17:56:36.000', '3265abb8-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('c13577ae-a6aa-41eb-b1f2-62af176891c4', NULL, '编辑任务', NULL, '328734a7-3aab-424d-8fb5-101a30335e3c', 2, 1, NULL, 'job:edit:entity', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-08-24 14:43:48.000', '00000000-0000-0000-0000-000000000000', '2021-08-24 14:43:48.000', '3265ac27-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('c1dc4140-ef7f-491e-a559-52614b581930', NULL, '编辑业务用户', NULL, 'ef3148eb-ebe6-4d9a-8806-aa783570290b', 3, 1, NULL, 'user:module:edit', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-07 16:23:41.207', '00000000-0000-0000-0000-000000000000', '2022-02-16 10:03:28.321', '3265ac97-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('c277f700-ac70-40f4-a290-28eddefac820', NULL, '查询列表', NULL, '63f294fb-eea5-41cf-8343-b43d60fdd680', 1, 2, NULL, 'import:config:query:list', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-04-29 15:15:21.000', '00000000-0000-0000-0000-000000000000', '2022-04-21 10:08:29.465', '3265ad01-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('c27d9de3-78ae-4577-8bdd-e4eea63010af', NULL, '查询列表', NULL, 'cf7929b6-f9d9-4100-85f9-f63582583a61', 1, 2, NULL, 'menu:query:list', '查询列表', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:05:09.000', '00000000-0000-0000-0000-000000000000', '2022-04-21 10:08:14.887', '3265ad6d-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('c3be9eb3-d1da-4af7-8820-aeaf0283cdec', NULL, '查询列表', NULL, 'b25958ea-608d-436f-8e01-b8fcc101905d', 1, 2, NULL, 'language:query:list', '', 0, '00000000-0000-0000-0000-000000000000', '2021-08-05 11:21:36.000', '00000000-0000-0000-0000-000000000000', '2022-04-21 10:08:54.253', '3265addb-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('c80f26ab-b2bc-4766-a40e-17ed9417a5c7', '/system', '角色管理', '/RoleManagement', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', 4, 0, 'theme', NULL, '角色管理菜单', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 16:10:47.000', '00000000-0000-0000-0000-000000000000', '2021-04-29 15:24:48.000', '3265ae47-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('cc21d837-43ed-49c1-bc5f-9bb647c1fd14', '/businessModule', '统一认证', '', NULL, 2, 0, 'table', NULL, '统一认证目录', 0, '00000000-0000-0000-0000-000000000000', '2022-01-26 15:07:54.148', '00000000-0000-0000-0000-000000000000', '2022-01-26 15:08:10.363', '3265aead-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('ccb42490-1389-40a2-86a0-ff77553bc740', NULL, '删除任务', NULL, '328734a7-3aab-424d-8fb5-101a30335e3c', 3, 1, NULL, 'job:del:entity', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-08-24 14:44:12.000', '00000000-0000-0000-0000-000000000000', '2021-08-24 14:44:12.000', '3265af13-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('cf7929b6-f9d9-4100-85f9-f63582583a61', '/system', '菜单管理', '/MenuManagement', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', 3, 0, 'list', NULL, '菜单管理', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 16:10:01.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 16:10:01.000', '3265af84-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('d0ebd39e-9a82-42fa-986e-c7235747a758', NULL, '查询列表', NULL, 'c80f26ab-b2bc-4766-a40e-17ed9417a5c7', 1, 2, NULL, 'role:query:list', '查询列表', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:16:44.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 18:16:44.000', '3265afec-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('d1bf1584-3c7a-4642-8cc6-095c42682e15', NULL, '查询列表', NULL, 'ef3148eb-ebe6-4d9a-8806-aa783570290b', 1, 2, NULL, 'user:module:list', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-01-26 17:33:36.375', '00000000-0000-0000-0000-000000000000', '2022-04-21 10:09:35.628', '3265b055-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('d25ea44a-4aba-47eb-b9ba-a42799d7a535', NULL, '新增菜单', NULL, 'cf7929b6-f9d9-4100-85f9-f63582583a61', 2, 1, NULL, 'menu:add:entity', '新增菜单', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:04:32.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 18:04:32.000', '3265b0c0-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('de435288-c697-4072-8215-394dc7f80ca6', NULL, '查询列表', NULL, 'e2363d77-45aa-4be1-b878-48d31aed728b', 1, 2, NULL, 'user:query:list', '查询列表', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:00:41.000', '00000000-0000-0000-0000-000000000000', '2022-04-08 17:28:00.702', '3265b14a-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('e2363d77-45aa-4be1-b878-48d31aed728b', '/system', '用户管理', '/UserManagement', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', 2, 0, 'user', NULL, '用户管理菜单', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 16:05:01.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 22:05:20.436', '3265b1ba-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('e2aaab2a-1b25-4e45-b54f-160bc6d332df', NULL, '新增用户', NULL, 'e2363d77-45aa-4be1-b878-48d31aed728b', 2, 1, NULL, 'user:add:entity', '新增用户', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:01:08.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 18:01:08.000', '3265b21f-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('e2bd72c3-b926-4072-b7a9-429cb77fe351', NULL, '模块访问授权', NULL, 'ef3148eb-ebe6-4d9a-8806-aa783570290b', 6, 1, NULL, 'user:module:grant', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-16 10:04:44.109', '00000000-0000-0000-0000-000000000000', '2022-02-16 10:04:44.109', '3265b298-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('eae2b1cf-26e5-4086-ae44-7f7f3c8a50d4', NULL, '删除配置', NULL, '63f294fb-eea5-41cf-8343-b43d60fdd680', 4, 1, NULL, 'import:config:del:entities', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-04-29 15:16:51.000', '00000000-0000-0000-0000-000000000000', '2021-04-29 15:16:51.000', '3265b305-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('eb926dd8-63ba-49a4-8445-df2850f763c9', NULL, '新增任务', NULL, '328734a7-3aab-424d-8fb5-101a30335e3c', 1, 1, NULL, 'job:add:entity', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-08-24 14:43:18.000', '00000000-0000-0000-0000-000000000000', '2021-08-24 14:43:18.000', '3265b375-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('ed4354fd-9611-41a9-abdc-383624db7a01', NULL, '查询列表', NULL, 'be4b8341-f1a7-473b-bad7-5b4b41732e49', 1, 2, NULL, 'user:query:onlineUsers', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-06-09 15:17:08.000', '00000000-0000-0000-0000-000000000000', '2022-04-21 10:08:38.094', '3265b3e1-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('eed891c4-822d-41d4-ac80-c6b9c327a1af', NULL, '离态用户授权', NULL, '03237dc0-d26f-4611-8fe1-ba08ac1da7d8', 2, 1, NULL, 'user:nonmodule:grant', '离态用户授权', 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 15:11:32.160', '00000000-0000-0000-0000-000000000000', '2022-05-03 09:45:21.711', '97398e2b-9303-40d4-87d6-2e919702d385');
INSERT INTO "sys_menu" VALUES ('ef3148eb-ebe6-4d9a-8806-aa783570290b', '/businessModule', '授权管理', '/BizUserModule', 'cc21d837-43ed-49c1-bc5f-9bb647c1fd14', 2, 0, 'list', NULL, '授权管理', 0, '00000000-0000-0000-0000-000000000000', '2022-01-26 17:24:20.373', '00000000-0000-0000-0000-000000000000', '2022-01-26 17:35:51.649', '3265b4bd-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('f21f1b48-b743-4e01-a5d7-c50ebfd2fe78', NULL, '删除字典', NULL, 'a27a2518-53d8-4ed2-9655-3e1781d615dd', 4, 1, NULL, 'code:del:entities', '删除字典', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:28:26.000', '00000000-0000-0000-0000-000000000000', '2021-12-18 21:39:38.690', '3265b524-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('f34914ab-50f3-4acf-b844-9cfc70834896', '/system', '服务器监控', '/ServerHardwareMonitor', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', 11, 0, 'form', NULL, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-12-10 16:37:41.453', '00000000-0000-0000-0000-000000000000', '2021-12-10 16:39:23.402', '3265b5d2-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('f425487a-72a1-469d-8fa1-2334db69aba4', NULL, '查询列表', NULL, 'a27a2518-53d8-4ed2-9655-3e1781d615dd', 1, 2, NULL, 'code:query:list', '查询列表', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 18:24:37.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 18:24:37.000', '3265b6de-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('f6d5b324-ed69-4246-82cd-cb9b3f80efa6', NULL, '导入用户', NULL, 'e2363d77-45aa-4be1-b878-48d31aed728b', 5, 1, NULL, 'user:import:entities', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 10:46:50.043', '00000000-0000-0000-0000-000000000000', '2022-02-18 10:46:50.043', '3265b78b-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('fb1f9114-e18c-4159-8af1-1408651f21fc', NULL, '编辑模块', NULL, 'a81bb7aa-d7c2-41b9-b616-b46d3d7d2cf3', 3, 1, NULL, 'module:edit:entity', '编辑模块', 0, '00000000-0000-0000-0000-000000000000', '2022-01-26 15:15:55.382', '00000000-0000-0000-0000-000000000000', '2022-01-26 16:49:48.904', '3265b801-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu" VALUES ('fb35235e-b771-462e-b84b-269f3d8938ce', NULL, '导入业务用户', NULL, 'ef3148eb-ebe6-4d9a-8806-aa783570290b', 5, 1, NULL, 'user:module:import', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-16 10:04:02.319', '00000000-0000-0000-0000-000000000000', '2022-02-16 10:04:02.319', '3265b86e-c9e7-11ec-a1af-002b67dcf564');
COMMIT;

-- ----------------------------
-- Table structure for sys_menu_language
-- ----------------------------
DROP TABLE IF EXISTS "sys_menu_language";
CREATE TABLE "sys_menu_language" (
  "id" text(36) NOT NULL,
  "menu_id" text(36) NOT NULL,
  "language_id" text(36) NOT NULL,
  "menu_name" text(128) NOT NULL,
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id"),
  CONSTRAINT "sml_languageid" FOREIGN KEY ("language_id") REFERENCES "sys_language" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT "sml_menuid" FOREIGN KEY ("menu_id") REFERENCES "sys_menu" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT
);

-- ----------------------------
-- Records of sys_menu_language
-- ----------------------------
BEGIN;
INSERT INTO "sys_menu_language" VALUES ('0bf54370-bd65-4a1c-8b6f-01fde552d168', 'b0652b6e-51ee-49ff-88b9-019bc8378f0b', '8223b5c4-c55a-4f02-98d2-ba7f320b0ea7', 'OrgManage', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-09-01 16:51:56.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:06:49.690', '3266c11b-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu_language" VALUES ('19b2fc8e-b374-43cc-8812-a056f2e87226', 'e2363d77-45aa-4be1-b878-48d31aed728b', '8223b5c4-c55a-4f02-98d2-ba7f320b0ea7', 'UserManage', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-09-01 17:13:02.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 22:05:20.450', '3266c4b5-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu_language" VALUES ('212d9b0c-86ac-4d1d-9fc0-8aadca1cc2bb', 'b0652b6e-51ee-49ff-88b9-019bc8378f0b', '8306a39f-bfbd-430f-8315-15b6ebe3861d', 'OrganizationManagement', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-05-01 22:03:20.294', '00000000-0000-0000-0000-000000000000', '2022-05-01 22:04:33.413', '3266c571-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu_language" VALUES ('6048abf8-ca30-45f4-90d8-7831eedb595e', 'e2363d77-45aa-4be1-b878-48d31aed728b', '8306a39f-bfbd-430f-8315-15b6ebe3861d', 'UserManagement', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-09-01 17:13:02.000', '00000000-0000-0000-0000-000000000000', '2021-09-01 17:13:02.000', '3266c60e-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu_language" VALUES ('629f10a6-60a6-4774-abdb-f88f1a76fd41', 'b0652b6e-51ee-49ff-88b9-019bc8378f0b', '8306a39f-bfbd-430f-8315-15b6ebe3861d', 'OrgManagement', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 22:04:33.420', '00000000-0000-0000-0000-000000000000', '2022-05-01 22:04:33.420', '3266c6a4-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu_language" VALUES ('b05c1fd6-b62e-4ab7-a78c-e30618d793a6', 'b0652b6e-51ee-49ff-88b9-019bc8378f0b', '8223b5c4-c55a-4f02-98d2-ba7f320b0ea7', 'OrgManagement', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 22:04:12.225', '00000000-0000-0000-0000-000000000000', '2022-05-01 22:04:12.225', '3266c72e-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu_language" VALUES ('bd79b7fe-b50d-410d-8ccd-c9320d784326', 'b0652b6e-51ee-49ff-88b9-019bc8378f0b', '8306a39f-bfbd-430f-8315-15b6ebe3861d', 'om', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:06:49.658', '00000000-0000-0000-0000-000000000000', '2022-05-01 22:03:20.283', '3266c7c2-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu_language" VALUES ('e8a2776e-9480-4c26-9371-db4fd3b768e7', 'b0652b6e-51ee-49ff-88b9-019bc8378f0b', '8223b5c4-c55a-4f02-98d2-ba7f320b0ea7', 'om', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:06:49.698', '00000000-0000-0000-0000-000000000000', '2022-05-01 22:04:12.217', '3266c85d-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu_language" VALUES ('ea4c0742-28ac-48c2-a7f5-31f0508c9e4b', 'b0652b6e-51ee-49ff-88b9-019bc8378f0b', '8306a39f-bfbd-430f-8315-15b6ebe3861d', 'OrganizationManagement', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-09-01 16:51:56.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:06:49.647', '3266c8e2-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_menu_language" VALUES ('f52d4a56-648c-4789-9449-b4d226cfddab', 'e2363d77-45aa-4be1-b878-48d31aed728b', '8223b5c4-c55a-4f02-98d2-ba7f320b0ea7', 'UserManagement', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 22:05:20.459', '00000000-0000-0000-0000-000000000000', '2022-05-01 22:05:20.459', '3266c96e-c9e7-11ec-a1af-002b67dcf564');
COMMIT;

-- ----------------------------
-- Table structure for sys_org_user
-- ----------------------------
DROP TABLE IF EXISTS "sys_org_user";
CREATE TABLE "sys_org_user" (
  "id" text(36) NOT NULL,
  "org_id" text(36) NOT NULL,
  "user_id" text(36) NOT NULL,
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id"),
  CONSTRAINT "sou_orgid" FOREIGN KEY ("org_id") REFERENCES "sys_organization" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT "sou_userid" FOREIGN KEY ("user_id") REFERENCES "sys_user" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT
);

-- ----------------------------
-- Records of sys_org_user
-- ----------------------------
BEGIN;
INSERT INTO "sys_org_user" VALUES ('02c0da63-02d3-4000-874c-da41deb37ab7', '9756e90f-9505-4990-ac0e-135c58bc6f29', 'a668aba7-b317-4468-a0fe-a2e024f0d303', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 11:08:13.478', '00000000-0000-0000-0000-000000000000', '2022-02-18 11:08:13.478', '325bcf56-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_org_user" VALUES ('046ee736-c4c8-440a-bb1e-93929d5a98e8', '9756e90f-9505-4990-ac0e-135c58bc6f29', 'fe89b5a8-7ec3-4227-848b-9eac418481c0', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-04-15 21:41:17.822', '00000000-0000-0000-0000-000000000000', '2022-04-15 21:41:17.822', '325bd9bc-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_org_user" VALUES ('0ce71313-2f99-4529-aa3c-bf08b3c613e7', 'ab907b1e-13a3-4c04-85db-f560f9c8f9aa', '45aeff89-2867-43e7-9b40-296233c069c5', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-04-09 11:46:45.000', '00000000-0000-0000-0000-000000000000', '2021-04-09 11:46:45.000', '325bdafe-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_org_user" VALUES ('258511fd-281e-4bb8-baee-71721e278651', '9756e90f-9505-4990-ac0e-135c58bc6f29', 'b464f199-3369-4dbd-ae7e-497224d5ea1d', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 11:08:04.504', '00000000-0000-0000-0000-000000000000', '2022-02-18 11:08:04.504', '325bdbf5-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_org_user" VALUES ('5ccc079d-b545-453b-b8c7-dbd64dc5d6c0', '9756e90f-9505-4990-ac0e-135c58bc6f29', 'bacc045e-eefc-4d45-9920-82192cbabb4e', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-18 12:03:33.728', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:49:16.338', '325bdced-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_org_user" VALUES ('67ee7a91-40e5-439c-b102-41864076ecae', '9756e90f-9505-4990-ac0e-135c58bc6f29', '44d83899-e4d8-4909-9eb7-969aa69a1ca8', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 12:08:56.847', '00000000-0000-0000-0000-000000000000', '2022-02-18 12:08:56.847', '325bdde9-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_org_user" VALUES ('727a3688-20d8-4186-b9d4-c76288d65f28', '9756e90f-9505-4990-ac0e-135c58bc6f29', '31cf3eed-848a-40a4-9c9d-75b2bac01d90', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 12:04:41.627', '00000000-0000-0000-0000-000000000000', '2022-02-18 12:04:41.627', '325bdecc-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_org_user" VALUES ('7599136a-e1aa-49c2-8ae8-7689e79d9857', '57126a11-842e-493d-bc4f-e8c18853e6ed', '6f415677-cc02-4efa-bfbd-fa7c1c2c561d', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-06-11 14:01:38.000', '00000000-0000-0000-0000-000000000000', '2021-06-11 14:01:38.000', '325bdfb4-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_org_user" VALUES ('a863f9ee-75d2-43ae-ab82-c0705bca87cc', '9756e90f-9505-4990-ac0e-135c58bc6f29', '92329bbc-a81d-4da9-b286-1a8a6444456b', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 10:59:11.955', '00000000-0000-0000-0000-000000000000', '2022-02-18 10:59:11.955', '325be096-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_org_user" VALUES ('c5390b02-69c5-4829-9d07-f1dc15379aab', '9756e90f-9505-4990-ac0e-135c58bc6f29', 'b09bbb4b-a7f0-4f7a-8f3d-dbb895f3edc5', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-04-11 12:14:37.000', '00000000-0000-0000-0000-000000000000', '2021-04-29 16:49:09.000', '325be17b-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_org_user" VALUES ('d6774ab4-5cec-46f5-912e-9a6cb3ae269e', '66255038-acda-49a4-b260-ccafeedc6074', '930cc8e2-f1ae-404d-9258-6167a3acbcbc', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-04-11 12:14:58.000', '00000000-0000-0000-0000-000000000000', '2021-04-29 16:49:09.000', '325be273-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_org_user" VALUES ('efc6d7fb-0d9e-4c5a-86b6-86b340ef2d5b', '9756e90f-9505-4990-ac0e-135c58bc6f29', 'f045968e-4eec-4a96-b0be-d84389456f10', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-04-15 21:41:17.737', '00000000-0000-0000-0000-000000000000', '2022-04-15 21:41:17.737', '325be350-c9e7-11ec-a1af-002b67dcf564');
COMMIT;

-- ----------------------------
-- Table structure for sys_organization
-- ----------------------------
DROP TABLE IF EXISTS "sys_organization";
CREATE TABLE "sys_organization" (
  "id" text(36) NOT NULL,
  "org_name" text(128) NOT NULL,
  "parent_id" text(36),
  "leader" text(36),
  "serial_number" integer,
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id")
);

-- ----------------------------
-- Records of sys_organization
-- ----------------------------
BEGIN;
INSERT INTO "sys_organization" VALUES ('39b86e17-1b98-4898-a1c0-8faef7f66788', 'DBA', '5a948c7d-56ea-477d-850e-1386f1dcdc2c', NULL, 6, '', 0, '00000000-0000-0000-0000-000000000000', '2021-04-08 10:00:45.000', '00000000-0000-0000-0000-000000000000', '2021-04-29 16:48:08.000', '3267b2b2-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_organization" VALUES ('504b3320-1b29-4493-98fd-e7d15f338569', 'UI设计', '5a948c7d-56ea-477d-850e-1386f1dcdc2c', NULL, 5, '', 0, '00000000-0000-0000-0000-000000000000', '2021-04-08 09:44:48.000', '00000000-0000-0000-0000-000000000000', '2022-04-18 14:04:46.472', '3267bdfb-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_organization" VALUES ('57126a11-842e-493d-bc4f-e8c18853e6ed', '硬件开发', '5a948c7d-56ea-477d-850e-1386f1dcdc2c', NULL, 2, '二级组织', 0, '00000000-0000-0000-0000-000000000000', '2021-04-08 09:29:54.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:48:32.038', '3267be8f-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_organization" VALUES ('5a948c7d-56ea-477d-850e-1386f1dcdc2c', '研发部', 'ab907b1e-13a3-4c04-85db-f560f9c8f9aa', NULL, 1, '一级部门', 0, '00000000-0000-0000-0000-000000000000', '2021-04-08 09:14:41.000', '00000000-0000-0000-0000-000000000000', '2022-06-09 10:54:22.316', '046866ad-1511-4488-b3d1-659d135817c5');
INSERT INTO "sys_organization" VALUES ('66255038-acda-49a4-b260-ccafeedc6074', '实施部', 'ab907b1e-13a3-4c04-85db-f560f9c8f9aa', NULL, 2, '一级部门', 0, '00000000-0000-0000-0000-000000000000', '2021-04-08 09:27:35.000', '00000000-0000-0000-0000-000000000000', '2021-04-08 09:27:48.000', '3267bf4f-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_organization" VALUES ('7955d133-040a-4e36-94fe-89c9c4a547e5', '售后部', 'ab907b1e-13a3-4c04-85db-f560f9c8f9aa', NULL, 3, '一级部门', 0, '00000000-0000-0000-0000-000000000000', '2021-04-08 09:28:46.000', '00000000-0000-0000-0000-000000000000', '2021-04-08 09:28:46.000', '3267bfad-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_organization" VALUES ('7d664253-e505-4157-83b0-01bb86028d66', '技术支持', '5a948c7d-56ea-477d-850e-1386f1dcdc2c', NULL, 7, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 10:59:25.000', '00000000-0000-0000-0000-000000000000', '2022-04-20 09:22:24.490', '3267c003-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_organization" VALUES ('8faffd3a-3bd2-4987-9cad-f658e83dc283', '系统测试', '5a948c7d-56ea-477d-850e-1386f1dcdc2c', NULL, 3, '系统测试', 0, '00000000-0000-0000-0000-000000000000', '2021-04-08 09:31:17.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 20:23:36.790', '3267c070-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_organization" VALUES ('9756e90f-9505-4990-ac0e-135c58bc6f29', '软件开发', '5a948c7d-56ea-477d-850e-1386f1dcdc2c', 'b09bbb4b-a7f0-4f7a-8f3d-dbb895f3edc5', 1, '二级组织', 0, '00000000-0000-0000-0000-000000000000', '2021-04-08 09:29:38', '00000000-0000-0000-0000-000000000000', '2022-06-10 15:19:54.4750126', '7b99cd49-ca90-4021-960d-b7e3a2dda4e2');
INSERT INTO "sys_organization" VALUES ('99b57766-c9f3-40ec-ac45-9d2cbe79ee08', '需求分析', '5a948c7d-56ea-477d-850e-1386f1dcdc2c', NULL, 4, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-04-08 10:00:13.000', '00000000-0000-0000-0000-000000000000', '2021-06-11 14:11:21.000', '3267c12b-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_organization" VALUES ('ab907b1e-13a3-4c04-85db-f560f9c8f9aa', '如意Admin', NULL, NULL, 1, '根本目录', 0, '00000000-0000-0000-0000-000000000000', '2021-03-14 12:38:56.000', '00000000-0000-0000-0000-000000000000', '2022-04-18 17:18:54.954', '3267c17f-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_organization" VALUES ('e4bcf807-6bd2-4aa5-ba6f-8ef85840fd65', '营销部', 'ab907b1e-13a3-4c04-85db-f560f9c8f9aa', NULL, 3, '一级部门', 0, '00000000-0000-0000-0000-000000000000', '2021-04-08 09:28:25.000', '00000000-0000-0000-0000-000000000000', '2021-04-08 09:28:25.000', '3267c1d3-c9e7-11ec-a1af-002b67dcf564');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS "sys_role";
CREATE TABLE "sys_role" (
  "id" text(36) NOT NULL,
  "role_name" text(128) NOT NULL,
  "serial_number" integer,
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id")
);

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO "sys_role" VALUES ('00793b23-7ed3-4e30-9906-0927f7f86543', 'Test1', 21, 'Test1', 0, '00000000-0000-0000-0000-000000000000', '2021-09-26 14:35:06.000', '00000000-0000-0000-0000-000000000000', '2021-09-26 14:35:06.000', '325d83f0-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role" VALUES ('2524bad7-0b2b-4c9f-b7cc-b91fa9a83f3b', 'Test2', 22, 'Test2', 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:21:53.942', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:21:53.942', '325d8de8-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role" VALUES ('40c3a340-4a71-489a-bdd7-c9f4eee1e743', '安全审计岗', 4, '安全审计角色', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 14:18:47.000', '00000000-0000-0000-0000-000000000000', '2021-04-11 16:19:42.000', '325d8f73-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role" VALUES ('43947b77-b453-4783-a3fc-81e6ab8e692c', '权限管理岗', 3, '权限管理', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 21:56:00.000', '00000000-0000-0000-0000-000000000000', '2021-04-29 15:29:49.000', '325d921f-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role" VALUES ('46a7abd1-ed2a-4617-bd38-f03b256efe84', '机构管理岗', 1, '机构管理角色', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 14:17:10.000', '00000000-0000-0000-0000-000000000000', '2021-09-23 14:38:29.000', '325d9359-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role" VALUES ('4c2f9410-f61e-45bb-96a5-655485f823d0', '统一认证', 6, '统一认证', 0, '00000000-0000-0000-0000-000000000000', '2021-12-03 16:40:24.864', '00000000-0000-0000-0000-000000000000', '2022-04-28 16:39:06.767', '325d94c5-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role" VALUES ('53ff963d-5e79-4836-9a04-de84ffedf611', 'Test1', 21, 'Test1', 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:21:53.88', '00000000-0000-0000-0000-000000000000', '2022-06-10 15:20:56.5657232', 'bbbf4071-1670-4eaf-87eb-b4afaf2c4f8e');
INSERT INTO "sys_role" VALUES ('a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', '用户管理岗', 2, '用户管理角色', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 21:55:28.000', '00000000-0000-0000-0000-000000000000', '2022-01-21 15:28:10.549', '325d979b-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role" VALUES ('df8af9fe-50c5-41b6-97dd-78e7d817c075', '数据字典管理岗', 5, '数据字典管理角色', 0, '00000000-0000-0000-0000-000000000000', '2021-04-10 14:20:20.000', '00000000-0000-0000-0000-000000000000', '2021-04-10 21:54:20.000', '325d993a-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role" VALUES ('f71a85a8-86bf-45e1-8160-70f329f0cbed', 'Test2', 22, 'Test2', 0, '00000000-0000-0000-0000-000000000000', '2021-09-26 14:35:06.000', '00000000-0000-0000-0000-000000000000', '2021-09-26 14:35:06.000', '325d9af7-c9e7-11ec-a1af-002b67dcf564');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS "sys_role_menu";
CREATE TABLE "sys_role_menu" (
  "id" text(36) NOT NULL,
  "role_id" text(36) NOT NULL,
  "menu_id" text(36) NOT NULL,
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id"),
  CONSTRAINT "srm_menuid" FOREIGN KEY ("menu_id") REFERENCES "sys_menu" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT "srm_roleid" FOREIGN KEY ("role_id") REFERENCES "sys_role" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT
);

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO "sys_role_menu" VALUES ('0120d05f-cabb-4263-8197-c65f26b21b36', 'a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', '4ef0101a-9911-47d0-8555-841ce928903f', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-04-11 16:17:25.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.045', '325fa3ca-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('061bd0ed-ca14-4898-bc29-45ab02527a59', '40c3a340-4a71-489a-bdd7-c9f4eee1e743', '0d12b992-92df-4961-a50b-a2aac55da1e2', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:11.668', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:11.668', '325fb1f4-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('0a8bad18-20c9-4118-92cc-d3e8da4015fd', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', 'e2bd72c3-b926-4072-b7a9-429cb77fe351', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:15.558', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.275', '325fb31a-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('0b81ee75-9067-4848-85bb-1e897b29b7bb', 'a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', 'de435288-c697-4072-8215-394dc7f80ca6', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.076', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.076', '325fb408-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('0e40ab16-84bb-4d75-9ed6-27b057b058f0', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', '1553af7d-5749-4894-8c3e-84cb3cf2f2dd', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:15.556', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.282', '325fb4d0-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('0ea56c75-4536-433f-a9e6-4669c2c98ff2', '43947b77-b453-4783-a3fc-81e6ab8e692c', '18cd9b4c-bfbd-442b-86dc-11eee193d886', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-04-11 16:17:43.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.729', '325fb5ab-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('0fc1ac60-8ab8-4685-b483-b649cb0b704e', '46a7abd1-ed2a-4617-bd38-f03b256efe84', 'b0652b6e-51ee-49ff-88b9-019bc8378f0b', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-12-03 16:26:09.970', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.581', '325fb667-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('11350e6a-b994-4ddc-8fa1-a4d1a048d895', '4c2f9410-f61e-45bb-96a5-655485f823d0', '0745a4ca-fb04-48d0-8ac5-7114acd15deb', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.091', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.091', '325fb740-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('12d442dd-ec97-4af6-9b60-084fb46e7cab', 'a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', 'e2aaab2a-1b25-4e45-b54f-160bc6d332df', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-04-11 16:17:25.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.049', '325fb7fe-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('1728685f-3ada-4ecc-b9ec-c40096d1fb69', '4c2f9410-f61e-45bb-96a5-655485f823d0', 'fb1f9114-e18c-4159-8af1-1408651f21fc', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.077', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.077', '325fb8af-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('1a3a0bbc-4545-4a09-858e-f39e6627a2ee', '46a7abd1-ed2a-4617-bd38-f03b256efe84', '371362df-0b05-4eee-9930-9288b6c8cc45', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.679', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.679', '325fb9e0-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('1ab766ad-b0f2-43f5-b8cb-563464cb2ee2', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', '78c1335e-f05a-4431-a85b-cee182b446f3', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:15.555', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.288', '325fbadc-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('1c7eeb5d-d8c6-4810-ab32-8b3a38978523', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', 'a27a2518-53d8-4ed2-9655-3e1781d615dd', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.353', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.353', '325fbba7-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('1e2627d8-820a-4f81-93c3-52c0296e9179', '46a7abd1-ed2a-4617-bd38-f03b256efe84', '8d549066-fe5d-466c-b540-3525ebf30def', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.667', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.667', '325fbc5d-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('1f505ff1-7994-4d58-9d83-c997cc316133', '40c3a340-4a71-489a-bdd7-c9f4eee1e743', '2923ffda-b4dc-4d92-9451-59a977a7edcb', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:11.670', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:11.670', '325fbd24-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('2038cb57-9e10-4ac5-a0e3-dbf0407944c9', '46a7abd1-ed2a-4617-bd38-f03b256efe84', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.662', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.662', '325fbdd6-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('27fb9328-f08a-4b5a-9ef3-fd1e99b50f11', '40c3a340-4a71-489a-bdd7-c9f4eee1e743', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:11.665', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:11.665', '325fbe86-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('296f87c7-20d9-43c3-b768-a338cc6e31b4', '4c2f9410-f61e-45bb-96a5-655485f823d0', '66469b10-a974-4abf-bd72-b7a205a09b47', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.078', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.078', '325fbf4d-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('29b710c1-c33e-4fac-88b9-320bec73f66f', '4c2f9410-f61e-45bb-96a5-655485f823d0', 'a81bb7aa-d7c2-41b9-b616-b46d3d7d2cf3', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.073', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.073', '325fc004-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('2b3a9db2-8883-47d7-81bf-0da7c2d5854c', '46a7abd1-ed2a-4617-bd38-f03b256efe84', 'e2aaab2a-1b25-4e45-b54f-160bc6d332df', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-12-03 16:26:10.073', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.585', '325fc10d-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('2cab3394-02a3-4b67-a029-231eb059029c', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', 'c1dc4140-ef7f-491e-a559-52614b581930', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:15.556', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.292', '325fc1cc-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('2fcec787-17e8-4a5d-a665-03949070c8d1', '40c3a340-4a71-489a-bdd7-c9f4eee1e743', '9321de30-10c8-4709-aff3-bba47312693f', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-04-11 16:18:01.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:11.645', '325fc27f-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('30399318-4014-4eef-adc1-2bea5ff12008', '4c2f9410-f61e-45bb-96a5-655485f823d0', 'fb35235e-b771-462e-b84b-269f3d8938ce', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.084', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.084', '325fc3b4-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('390bda43-f6e8-4099-adab-aa7cb5cf2524', 'a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', 'e2363d77-45aa-4be1-b878-48d31aed728b', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-04-11 16:17:25.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.054', '325fc47a-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('3c49249d-a4a4-4081-873b-32112cf153d5', 'a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', 'de435288-c697-4072-8215-394dc7f80ca6', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-04-11 16:17:25.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.058', '325fc52b-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('3d312ee5-70e3-4b1d-be84-b6ad700e69ad', '46a7abd1-ed2a-4617-bd38-f03b256efe84', '45c8b9cf-5ac2-4e42-9cc8-051871a1d63f', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-12-03 16:26:09.988', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.590', '325fc5dc-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('40670af8-9fa1-40b9-9802-c4df2580e141', '40c3a340-4a71-489a-bdd7-c9f4eee1e743', '0d12b992-92df-4961-a50b-a2aac55da1e2', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-04-11 16:18:01.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:11.649', '325fc68b-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('45e51444-c53b-4162-aa6d-013ebaecbf09', '43947b77-b453-4783-a3fc-81e6ab8e692c', '0e989075-01cd-4c6e-a622-d336106bf255', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.766', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.766', '325fc73b-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('46068ab7-f91a-4a5b-b31c-c57f9189663e', '46a7abd1-ed2a-4617-bd38-f03b256efe84', '26d0ed04-5670-4707-ad91-e2893edca2ed', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.671', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.671', '325fc7f0-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('48d18f97-7c54-4028-b0db-218ac169f2fd', '46a7abd1-ed2a-4617-bd38-f03b256efe84', 'bec177ff-23ce-449f-ade4-dd0e62142842', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.669', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.669', '325fc89d-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('49c63952-9153-43ca-bb3f-a81b5199e909', '4c2f9410-f61e-45bb-96a5-655485f823d0', 'eed891c4-822d-41d4-ac80-c6b9c327a1af', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.087', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.087', '325fc958-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('4bc18573-f849-4ccb-b377-403e893fa761', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', 'cc21d837-43ed-49c1-bc5f-9bb647c1fd14', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:15.545', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.296', '325fca07-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('4be06a2a-13cd-40f6-a5fc-6b251a0a41cd', '46a7abd1-ed2a-4617-bd38-f03b256efe84', '45c8b9cf-5ac2-4e42-9cc8-051871a1d63f', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.666', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.666', '325fcac2-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('4c85d471-a037-48ca-afed-f22256530513', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', 'f425487a-72a1-469d-8fa1-2334db69aba4', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.354', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.354', '325fcb75-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('4eb23879-bad1-4543-b9a6-8da470822284', '4c2f9410-f61e-45bb-96a5-655485f823d0', '300a8888-11af-4272-a638-baefc8e7858d', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.092', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.092', '325fcc27-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('50de7f7c-f006-4f2c-ae04-02981c65cf1d', '46a7abd1-ed2a-4617-bd38-f03b256efe84', 'bec177ff-23ce-449f-ade4-dd0e62142842', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-12-03 16:26:10.019', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.594', '325fccd6-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('59b92f21-646e-4b49-a586-3f416d45cb0b', '4c2f9410-f61e-45bb-96a5-655485f823d0', 'c1dc4140-ef7f-491e-a559-52614b581930', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.082', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.082', '325fcd8b-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('5ad3fea9-c150-4456-ad26-7aecd4d7fdbb', '43947b77-b453-4783-a3fc-81e6ab8e692c', '837a330f-11bd-4a70-93b5-25af2c905408', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-04-11 16:17:43.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.733', '325fce74-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('5b69f53f-d52b-40b5-a299-dbc0b5dcf109', '46a7abd1-ed2a-4617-bd38-f03b256efe84', '8d549066-fe5d-466c-b540-3525ebf30def', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-12-03 16:26:10.005', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.599', '325fcf29-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('62cc88f4-0887-4ac2-be81-fafe99016793', '43947b77-b453-4783-a3fc-81e6ab8e692c', 'd0ebd39e-9a82-42fa-986e-c7235747a758', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.765', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.765', '325fcfd9-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('6376a340-2935-433e-8ece-120428d83f9d', '43947b77-b453-4783-a3fc-81e6ab8e692c', '0e989075-01cd-4c6e-a622-d336106bf255', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-04-11 16:17:43.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.736', '325fd10c-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('681c6b65-3323-4f8a-9df1-6e23b9c78769', 'a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', 'f6d5b324-ed69-4246-82cd-cb9b3f80efa6', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.081', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.081', '325fd1c2-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('6b3c11a4-3e4f-4642-99f5-f5aae5981de8', '46a7abd1-ed2a-4617-bd38-f03b256efe84', 'de435288-c697-4072-8215-394dc7f80ca6', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.674', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.674', '325fd272-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('6de4b0c7-a4c0-4766-a668-21378851f334', '4c2f9410-f61e-45bb-96a5-655485f823d0', '78c1335e-f05a-4431-a85b-cee182b446f3', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.081', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.081', '325fd3a4-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('6f0d6215-8fe3-49cc-b161-3013a7b66f11', '46a7abd1-ed2a-4617-bd38-f03b256efe84', 'de435288-c697-4072-8215-394dc7f80ca6', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-12-03 16:26:10.061', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.603', '325fd453-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('71e86fff-7f74-4773-b9c9-2d874cbc1f5b', '46a7abd1-ed2a-4617-bd38-f03b256efe84', 'e2363d77-45aa-4be1-b878-48d31aed728b', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-12-03 16:26:10.048', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.608', '325fd500-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('73c66d2e-cd9a-40ef-8f4f-3072bd4a8036', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', 'af62fa5d-4808-4a59-9297-58b0df442fff', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:15.549', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.300', '325fd5b6-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('7662765d-0b3d-435f-9632-6ec07bd58184', 'a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', 'e2aaab2a-1b25-4e45-b54f-160bc6d332df', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.077', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.077', '325fd668-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('78a3e20f-2996-4e3d-9e7c-1cd1ee6f6973', '46a7abd1-ed2a-4617-bd38-f03b256efe84', 'e2aaab2a-1b25-4e45-b54f-160bc6d332df', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.676', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.676', '325fd718-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('7baf2a7b-e100-49f8-8acf-f8aee3336f97', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', '66469b10-a974-4abf-bd72-b7a205a09b47', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:15.551', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.305', '325fdfe7-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('7c55c6ae-6dcc-4c50-ae8f-7c61f663f45e', '40c3a340-4a71-489a-bdd7-c9f4eee1e743', '9321de30-10c8-4709-aff3-bba47312693f', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:11.666', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:11.666', '325fe1cc-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('7e09ed45-9b23-411c-be23-a84d6cec41cc', '4c2f9410-f61e-45bb-96a5-655485f823d0', 'cc21d837-43ed-49c1-bc5f-9bb647c1fd14', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.072', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.072', '325fe2da-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('82381b65-c794-4284-80cc-fb2ea378b9f9', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', 'f21f1b48-b743-4e01-a5d7-c50ebfd2fe78', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.357', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.357', '325fe39b-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('86438cc2-8eb8-40b2-b8ce-d4f4e831d81d', '4c2f9410-f61e-45bb-96a5-655485f823d0', 'af62fa5d-4808-4a59-9297-58b0df442fff', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.075', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.075', '325fe453-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('86c2008c-4d75-4989-896b-5c6ce1455f8e', 'a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', '371362df-0b05-4eee-9930-9288b6c8cc45', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-04-11 16:17:25.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.062', '325fe50a-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('875e822a-9603-4468-891e-f33ed99f43b4', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', 'fb1f9114-e18c-4159-8af1-1408651f21fc', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:15.550', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.308', '325fe608-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('881a4d5e-cd6a-46d6-972f-59ecde62e56f', '43947b77-b453-4783-a3fc-81e6ab8e692c', '60f51a50-7fb8-47df-bbee-20a4bb29d650', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-04-11 16:17:43.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.740', '325fe6d5-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('89aca8d7-5cf3-464f-88ae-77d39e52abc1', '43947b77-b453-4783-a3fc-81e6ab8e692c', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.762', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.762', '325fe78f-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('933e5f3c-493d-4018-9f5a-0a5de20c6371', '4c2f9410-f61e-45bb-96a5-655485f823d0', '03237dc0-d26f-4611-8fe1-ba08ac1da7d8', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.085', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.085', '325fe844-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('9630a433-624a-4f65-a7b8-2e1ac71971a8', '4c2f9410-f61e-45bb-96a5-655485f823d0', '8169ab55-b24e-45b5-99f1-9d65d55af215', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.074', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.074', '325fe903-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('9770de5b-b6f3-4ddf-b247-c8cbdff8bb95', '46a7abd1-ed2a-4617-bd38-f03b256efe84', 'b0652b6e-51ee-49ff-88b9-019bc8378f0b', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.664', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.664', '325fe9fd-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('9837e688-41d3-47d9-af6d-a8b808f4056c', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', 'eed891c4-822d-41d4-ac80-c6b9c327a1af', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:15.562', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.312', '325fead2-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('9a10f2c7-40f8-4a83-b946-0223fa8ddce3', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', 'd1bf1584-3c7a-4642-8cc6-095c42682e15', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:15.554', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.316', '325feb83-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('9b8dd0ba-8179-44e1-8f91-ea31005f2af7', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', 'ef3148eb-ebe6-4d9a-8806-aa783570290b', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:15.552', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.320', '325fecb8-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('9bdc84fd-fb2c-4d7c-98d6-ce82e5b9cfed', '4c2f9410-f61e-45bb-96a5-655485f823d0', 'e2bd72c3-b926-4072-b7a9-429cb77fe351', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.085', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.085', '325fed71-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('9d5666d4-4c63-48a1-aeec-0a81478502a5', '43947b77-b453-4783-a3fc-81e6ab8e692c', 'a4416f30-7381-48d2-a074-b2e9a9481c3c', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.773', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.773', '325fee25-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('9d830ea6-2fca-4cbb-acda-03c9b041cc97', '43947b77-b453-4783-a3fc-81e6ab8e692c', 'a4a59f63-f397-4850-ac4a-b06b41acfc34', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.771', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.771', '325feed7-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('a1a2f566-fce2-4599-82f5-4a7059053695', '43947b77-b453-4783-a3fc-81e6ab8e692c', 'c80f26ab-b2bc-4766-a40e-17ed9417a5c7', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.764', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.764', '325ff023-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('a3b0368f-c320-4041-b934-29492fdd39c9', '4c2f9410-f61e-45bb-96a5-655485f823d0', '66d87039-4811-4ba8-87b4-e53ed0daf21f', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.089', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.089', '325ff0df-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('a47fd7b0-aa82-4ef6-b611-58513d4cfc13', 'a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', 'e2363d77-45aa-4be1-b878-48d31aed728b', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.074', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.074', '325ff199-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('a5b7a194-508c-4abc-bf8e-962a752aad67', '46a7abd1-ed2a-4617-bd38-f03b256efe84', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-12-03 16:26:09.954', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.614', '325ff257-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('a5cbe61c-33df-4521-8f3d-9fa0f83f7885', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', '206bb7dc-101a-4d76-89fc-606cdd247355', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:15.561', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.324', '325ff307-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('abd595ee-0d68-422e-91fb-d90263c8e549', '43947b77-b453-4783-a3fc-81e6ab8e692c', 'b807f782-8b8c-49b6-a62d-e230dd44cd7e', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.768', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.768', '325ff3b6-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('accb05c9-65b4-4cbd-af42-03f88ce6e1ba', '43947b77-b453-4783-a3fc-81e6ab8e692c', '4c4126b1-8c20-44a5-a2cf-9ea19e582af9', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.772', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.772', '325ff4fc-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('ace65d33-bb40-4705-911b-e4eeea987a35', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', '2634a816-5dd9-4bfd-a573-f6b0020204db', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.356', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.356', '325ff5e9-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('ad9944f7-00bc-4cca-97f8-3a558d625f18', '4c2f9410-f61e-45bb-96a5-655485f823d0', '1bb376e1-c420-4bd4-ab39-75f569095ea4', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.088', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.088', '325ff6a3-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('b262698b-d553-49d4-aeda-50c8bd570ee5', '46a7abd1-ed2a-4617-bd38-f03b256efe84', 'f6d5b324-ed69-4246-82cd-cb9b3f80efa6', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.680', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.680', '325ff770-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('b45a293d-777b-4895-ab88-747878ecd04d', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', '8169ab55-b24e-45b5-99f1-9d65d55af215', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:15.548', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.328', '325ff829-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('b5c92981-f316-4289-bd1c-51305938f1fe', '43947b77-b453-4783-a3fc-81e6ab8e692c', '60f51a50-7fb8-47df-bbee-20a4bb29d650', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.767', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.767', '325ff8db-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('b78a5f50-922e-432c-964c-890f548c76a8', '4c2f9410-f61e-45bb-96a5-655485f823d0', '1553af7d-5749-4894-8c3e-84cb3cf2f2dd', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.083', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.083', '325ff994-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('b7fc5983-21b6-4111-a9bc-069f548353dc', '4c2f9410-f61e-45bb-96a5-655485f823d0', 'd1bf1584-3c7a-4642-8cc6-095c42682e15', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.080', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.080', '325ffa48-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('b8c5b78c-14da-4dbb-875d-75550470a627', '4c2f9410-f61e-45bb-96a5-655485f823d0', '7ffd51d8-3475-4b82-a0e7-bd5e92e5f174', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.090', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.090', '325ffaf9-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('bf12c5b1-1483-4925-9c6e-79527a816ac4', 'a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.072', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.072', '325ffc41-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('c51a4d14-a462-4f26-a14a-d853f21ec790', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', '13e73c0d-a285-43af-9167-eef89381d08e', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.355', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.355', '325ffcfe-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('c6322e43-2ee5-4f4e-9bd5-751dc41fb53b', '46a7abd1-ed2a-4617-bd38-f03b256efe84', 'e2363d77-45aa-4be1-b878-48d31aed728b', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.672', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.672', '325ffe00-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('c81be673-9065-4046-a16e-c705a9440fe1', '43947b77-b453-4783-a3fc-81e6ab8e692c', 'b807f782-8b8c-49b6-a62d-e230dd44cd7e', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-04-11 16:17:43.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.744', '325ffec1-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('cd33f801-eed3-44a8-be02-e97a13e471a0', '43947b77-b453-4783-a3fc-81e6ab8e692c', 'd0ebd39e-9a82-42fa-986e-c7235747a758', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-04-11 16:17:43.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.748', '325fff77-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('d0c677b2-ca69-4ec4-8a6e-5bbfff9d90f5', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', '03237dc0-d26f-4611-8fe1-ba08ac1da7d8', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:15.560', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.332', '3260002a-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('d206cc5f-93b3-4d3b-9bff-24e9b899339b', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', 'fb35235e-b771-462e-b84b-269f3d8938ce', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:15.558', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.337', '326000db-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('d5334fcf-c37a-44d3-8ee1-4821e42a0c15', '46a7abd1-ed2a-4617-bd38-f03b256efe84', '371362df-0b05-4eee-9930-9288b6c8cc45', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-12-03 16:26:10.100', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.618', '3260018c-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('d566b787-1d37-41b5-a298-43b1eb259e34', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', 'aa0a8b78-5e35-46f5-be7e-2a55f20f6470', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.352', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.352', '32600248-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('da87d20e-8f97-4fe4-82a6-367e8254bf8e', '43947b77-b453-4783-a3fc-81e6ab8e692c', '837a330f-11bd-4a70-93b5-25af2c905408', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.769', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.769', '32600be1-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('dac74003-0e7e-4fa7-b3c4-fe7f7bc35c09', '46a7abd1-ed2a-4617-bd38-f03b256efe84', '26d0ed04-5670-4707-ad91-e2893edca2ed', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-12-03 16:26:10.033', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.624', '32600ced-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('dd6476d7-7fd2-4057-bb64-df5d4c589637', 'a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', '4ef0101a-9911-47d0-8555-841ce928903f', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.079', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.079', '32600dab-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('e39ec5e8-f41e-4011-a7a0-54c12853cbd1', '46a7abd1-ed2a-4617-bd38-f03b256efe84', '4ef0101a-9911-47d0-8555-841ce928903f', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.677', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.677', '32600e60-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('e426bce5-6045-418e-b169-1480af3fbb4e', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', 'a81bb7aa-d7c2-41b9-b616-b46d3d7d2cf3', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:15.547', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:34.342', '32600fb7-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('e5b68142-acbd-4e69-9f02-a70b4fea92bd', 'a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', '371362df-0b05-4eee-9930-9288b6c8cc45', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.080', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:45.080', '32601078-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('ec8ca9c7-53d5-459e-859e-3d7db48de4d6', '43947b77-b453-4783-a3fc-81e6ab8e692c', 'c80f26ab-b2bc-4766-a40e-17ed9417a5c7', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-04-11 16:17:43.000', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.752', '32601136-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('ecae4db3-751d-409e-b9d7-f5910c215a03', '46a7abd1-ed2a-4617-bd38-f03b256efe84', '4ef0101a-9911-47d0-8555-841ce928903f', NULL, 1, '00000000-0000-0000-0000-000000000000', '2021-12-03 16:26:10.088', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:30.630', '326011e6-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('f0694e9d-7ff2-4498-9302-94094e45c999', '4c2f9410-f61e-45bb-96a5-655485f823d0', 'ef3148eb-ebe6-4d9a-8806-aa783570290b', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.079', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.079', '32601296-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('f0c605b7-1422-4a43-9303-d5f2b90bb99f', '43947b77-b453-4783-a3fc-81e6ab8e692c', '18cd9b4c-bfbd-442b-86dc-11eee193d886', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.770', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:22:59.770', '32601351-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_menu" VALUES ('f7d2f303-6c69-43df-8532-4538b558e9a8', '4c2f9410-f61e-45bb-96a5-655485f823d0', '206bb7dc-101a-4d76-89fc-606cdd247355', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.086', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:23:57.086', '32601404-c9e7-11ec-a1af-002b67dcf564');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_org
-- ----------------------------
DROP TABLE IF EXISTS "sys_role_org";
CREATE TABLE "sys_role_org" (
  "id" text(36) NOT NULL,
  "role_id" text(36) NOT NULL,
  "org_id" text(36) NOT NULL,
  "owner_type" integer NOT NULL,
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id"),
  CONSTRAINT "srg_orgid" FOREIGN KEY ("org_id") REFERENCES "sys_organization" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT "srg_roleid" FOREIGN KEY ("role_id") REFERENCES "sys_role" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT
);

-- ----------------------------
-- Records of sys_role_org
-- ----------------------------
BEGIN;
INSERT INTO "sys_role_org" VALUES ('151a05c1-2881-4148-9f32-762a61d90bb1', '53ff963d-5e79-4836-9a04-de84ffedf611', 'ab907b1e-13a3-4c04-85db-f560f9c8f9aa', 0, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:21:53.925', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:21:53.925', '32618e6a-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_org" VALUES ('18dbd954-f3e4-401d-8a17-01ad429048d9', '46a7abd1-ed2a-4617-bd38-f03b256efe84', '9756e90f-9505-4990-ac0e-135c58bc6f29', 1, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-03 09:46:39.782', '00000000-0000-0000-0000-000000000000', '2022-05-03 09:46:39.782', '0e6907b0-9344-44c8-bb90-982faddd1117');
INSERT INTO "sys_role_org" VALUES ('2309b2c9-5009-4b33-a490-e6e513e8cd25', '46a7abd1-ed2a-4617-bd38-f03b256efe84', '9756e90f-9505-4990-ac0e-135c58bc6f29', 1, NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:45:44.381', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:45:47.645', '32619773-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_org" VALUES ('354845ca-eace-4d95-a65a-37496580c517', '40c3a340-4a71-489a-bdd7-c9f4eee1e743', 'ab907b1e-13a3-4c04-85db-f560f9c8f9aa', 0, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-11-09 16:02:29.000', '00000000-0000-0000-0000-000000000000', '2021-11-09 16:47:19.000', '326198be-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_org" VALUES ('354845ca-eace-4d95-a65a-37496580c518', '46a7abd1-ed2a-4617-bd38-f03b256efe84', 'ab907b1e-13a3-4c04-85db-f560f9c8f9aa', 0, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-11-09 16:40:50.000', '00000000-0000-0000-0000-000000000000', '2021-11-09 16:48:39.000', '326199b3-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_org" VALUES ('354845ca-eace-4d95-a65a-37496580c519', 'a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', 'ab907b1e-13a3-4c04-85db-f560f9c8f9aa', 0, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-11-09 16:02:29.000', '00000000-0000-0000-0000-000000000000', '2021-11-09 16:47:19.000', '32619a98-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_org" VALUES ('668cd0f8-711f-4076-a315-100ae5ebbf84', '2524bad7-0b2b-4c9f-b7cc-b91fa9a83f3b', 'ab907b1e-13a3-4c04-85db-f560f9c8f9aa', 0, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:21:53.946', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:21:53.946', '32619b7f-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_org" VALUES ('672d6f9b-c295-4972-a71e-56a566f68f88', '43947b77-b453-4783-a3fc-81e6ab8e692c', 'ab907b1e-13a3-4c04-85db-f560f9c8f9aa', 0, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-11-09 16:40:50.000', '00000000-0000-0000-0000-000000000000', '2021-11-09 16:48:39.000', '32619c5b-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_org" VALUES ('8ee4a37b-593d-460a-beb9-88d9ab2cdb7c', '4c2f9410-f61e-45bb-96a5-655485f823d0', 'ab907b1e-13a3-4c04-85db-f560f9c8f9aa', 0, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-12-03 16:40:25.000', '00000000-0000-0000-0000-000000000000', '2021-12-03 16:40:25.000', '32619d3a-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_org" VALUES ('e50ee78e-ee79-4058-b5b0-7cc31114f9af', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', 'ab907b1e-13a3-4c04-85db-f560f9c8f9aa', 0, NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-11-09 16:40:45.000', '00000000-0000-0000-0000-000000000000', '2021-11-09 16:47:38.000', '32619e0d-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_org" VALUES ('e6558da7-fefe-4441-95f2-5d954d4c4abd', 'a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', '9756e90f-9505-4990-ac0e-135c58bc6f29', 1, NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:46:51.635', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:46:51.635', '32619f00-c9e7-11ec-a1af-002b67dcf564');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_user
-- ----------------------------
DROP TABLE IF EXISTS "sys_role_user";
CREATE TABLE "sys_role_user" (
  "id" text(36) NOT NULL,
  "role_id" text(36) NOT NULL,
  "user_id" text(36) NOT NULL,
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id"),
  CONSTRAINT "sru_roleid" FOREIGN KEY ("role_id") REFERENCES "sys_role" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT "sru_userid" FOREIGN KEY ("user_id") REFERENCES "sys_user" ("id") ON DELETE RESTRICT ON UPDATE RESTRICT
);

-- ----------------------------
-- Records of sys_role_user
-- ----------------------------
BEGIN;
INSERT INTO "sys_role_user" VALUES ('0a1d385e-5bc6-4648-8d43-bad5b642fd7c', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', '930cc8e2-f1ae-404d-9258-6167a3acbcbc', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-04-12 11:39:37.000', '00000000-0000-0000-0000-000000000000', '2021-04-12 11:39:37.000', '326288f7-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_user" VALUES ('2c640cc3-638e-4fde-9839-a146d702afa8', 'a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', 'a668aba7-b317-4468-a0fe-a2e024f0d303', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:46:47.070', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:46:47.070', '326291f4-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_user" VALUES ('45f9b5a2-7b43-43bb-8544-b774488535d6', 'a59ec5b3-9e0c-4ca9-a13b-1a0b159c928b', '930cc8e2-f1ae-404d-9258-6167a3acbcbc', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-04-11 16:15:58.000', '00000000-0000-0000-0000-000000000000', '2021-04-11 16:15:58.000', '32629319-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_user" VALUES ('740135f9-568f-476b-91de-583f4efc6b8d', 'df8af9fe-50c5-41b6-97dd-78e7d817c075', '45aeff89-2867-43e7-9b40-296233c069c5', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:42.488', '00000000-0000-0000-0000-000000000000', '2022-02-24 14:15:42.488', '326293f8-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_user" VALUES ('c6999828-2fd3-43bb-adbf-d5bbcd4de1b7', '46a7abd1-ed2a-4617-bd38-f03b256efe84', '45aeff89-2867-43e7-9b40-296233c069c5', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-04-29 15:33:23.000', '00000000-0000-0000-0000-000000000000', '2021-04-29 15:33:23.000', '326294d4-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_user" VALUES ('d73b64a4-3b0c-469f-95a3-11d75c8fb0d0', '46a7abd1-ed2a-4617-bd38-f03b256efe84', 'b09bbb4b-a7f0-4f7a-8f3d-dbb895f3edc5', NULL, 1, '00000000-0000-0000-0000-000000000000', '2022-05-01 21:45:33.403', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:45:47.683', '326295ae-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_user" VALUES ('dafb911b-c2b2-42c1-aa16-9b704128c5b4', '46a7abd1-ed2a-4617-bd38-f03b256efe84', '930cc8e2-f1ae-404d-9258-6167a3acbcbc', NULL, 0, '00000000-0000-0000-0000-000000000000', '2021-04-29 15:33:23.000', '00000000-0000-0000-0000-000000000000', '2021-04-29 15:33:23.000', '3262967e-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_role_user" VALUES ('f4439486-1853-436b-82f3-b1333aa18670', '46a7abd1-ed2a-4617-bd38-f03b256efe84', 'a668aba7-b317-4468-a0fe-a2e024f0d303', NULL, 0, '00000000-0000-0000-0000-000000000000', '2022-05-03 09:46:34.509', '00000000-0000-0000-0000-000000000000', '2022-05-03 09:46:34.509', '2ff9a579-8c02-4955-bb9b-d54de53e80ab');
COMMIT;

-- ----------------------------
-- Table structure for sys_schedule_job
-- ----------------------------
DROP TABLE IF EXISTS "sys_schedule_job";
CREATE TABLE "sys_schedule_job" (
  "id" text(36) NOT NULL,
  "job_name" text(128) NOT NULL,
  "job_description" text(512),
  "namespace" text(512) NOT NULL,
  "job_implement" text(128) NOT NULL,
  "cron_expression" text(128) NOT NULL,
  "start_time" text,
  "end_time" text,
  "job_status" integer NOT NULL,
  "group_id" integer,
  "serial_number" integer,
  "remark" text(512),
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id")
);

-- ----------------------------
-- Records of sys_schedule_job
-- ----------------------------
BEGIN;
INSERT INTO "sys_schedule_job" VALUES ('10f976a2-f9ef-4629-8f43-9afce17c2a9d', '邮件发送任务', '定时发送邮件作业', 'RuYiAdmin.Net.Service.QuartzJobs', 'EmailJob', '0/5 * * * * ?', '2021-09-10 10:19:12', '9999-12-31 00:00:00', 1, 1, 2, '定时发送邮件作业', 0, '00000000-0000-0000-0000-000000000000', '2021-09-10 10:16:47.000', 'c5604c2c-c1ca-4c18-8bc1-2bb8544e1b99', '2022-04-19 10:47:01.857', '32637ae9-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_schedule_job" VALUES ('8df4699c-b4d4-468f-9037-df49cd5a62dd', '定时短信任务', '定时发送短信作业', 'RuYiAdmin.Net.Service.QuartzJobs', 'MessageJob', '0/5 * * * * ?', '2021-09-10 09:46:28', '9999-12-31 00:00:00', 1, 1, 1, '定时短信任务作业', 0, '00000000-0000-0000-0000-000000000000', '2021-09-10 09:33:43.000', 'd44ad582-61be-41eb-b3ab-59fab0505a82', '2022-05-03 09:48:07.128', '2b31faf7-53ab-4d24-b6ca-ae5b7fb3cf0e');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS "sys_user";
CREATE TABLE "sys_user" (
  "id" text(36) NOT NULL,
  "logon_name" text(128) NOT NULL,
  "display_name" text(128) NOT NULL,
  "password" text(512),
  "telephone" text(45),
  "mobilephone" text(45),
  "email" text(45),
  "remark" text(512),
  "is_supper_admin" integer,
  "serial_number" integer,
  "is_enabled" integer NOT NULL,
  "isdel" integer NOT NULL,
  "creator" text(36) NOT NULL,
  "create_time" text(3) NOT NULL,
  "modifier" text(36) NOT NULL,
  "modify_time" text(3) NOT NULL,
  "version_id" text(36) NOT NULL,
  PRIMARY KEY ("id")
);

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO "sys_user" VALUES ('00000000-0000-0000-0000-000000000000', 'admin', '超级管理员', 'kcAVKc+BvoWtRUcIwXZ72w==', NULL, NULL, NULL, NULL, 1, 0, 1, 0, '00000000-0000-0000-0000-000000000000', '2021-04-09 11:46:43.000', '00000000-0000-0000-0000-000000000000', '2021-04-09 11:46:43.000', '325a76f3-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_user" VALUES ('31cf3eed-848a-40a4-9c9d-75b2bac01d90', 'zhangsan12', '张三', 'kcAVKc+BvoWtRUcIwXZ72w==', '010-55558888', 13555556666, '123@abc.com', NULL, 0, 2, 1, 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 12:04:41.615', '00000000-0000-0000-0000-000000000000', '2022-04-13 16:29:16.349', '325a82a2-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_user" VALUES ('44d83899-e4d8-4909-9eb7-969aa69a1ca8', 'lisi122', '李四', 'kcAVKc+BvoWtRUcIwXZ72w==', '010-55558889', 13555556667, '456@abc.com', NULL, 0, 0, 1, 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 12:08:56.839', '00000000-0000-0000-0000-000000000000', '2022-02-18 12:08:56.839', '325a8406-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_user" VALUES ('45aeff89-2867-43e7-9b40-296233c069c5', 'ruyi', '如意', 'kcAVKc+BvoWtRUcIwXZ72w==', '010-55558888', 13555556666, 'ruyi@qq.com', '如意小朋友', 0, 1, 1, 0, '00000000-0000-0000-0000-000000000000', '2021-04-09 11:46:43', '00000000-0000-0000-0000-000000000000', '2022-06-10 15:20:14.9135609', '39695644-082a-4c20-bbb7-3bb08bbe16b1');
INSERT INTO "sys_user" VALUES ('6f415677-cc02-4efa-bfbd-fa7c1c2c561d', 'hello', '你好', 'kcAVKc+BvoWtRUcIwXZ72w==', NULL, NULL, NULL, 'xx', 0, 1, 1, 0, '00000000-0000-0000-0000-000000000000', '2021-06-11 14:01:38.000', '00000000-0000-0000-0000-000000000000', '2021-07-02 16:04:25.000', '325a85cf-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_user" VALUES ('92329bbc-a81d-4da9-b286-1a8a6444456b', 'zhangsan', '张三', 'kcAVKc+BvoWtRUcIwXZ72w==', '010-55558888', 13555556666, '123@abc.com', NULL, 0, 0, 1, 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 10:59:09.629', '00000000-0000-0000-0000-000000000000', '2022-02-18 10:59:09.629', '325a86b5-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_user" VALUES ('930cc8e2-f1ae-404d-9258-6167a3acbcbc', 'shisih', '实施', 'kcAVKc+BvoWtRUcIwXZ72w==', NULL, NULL, NULL, 'pp', 0, 1, 1, 0, '00000000-0000-0000-0000-000000000000', '2021-04-11 12:14:58.000', '00000000-0000-0000-0000-000000000000', '2021-06-11 13:58:56.000', '325a8787-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_user" VALUES ('a668aba7-b317-4468-a0fe-a2e024f0d303', 'lisi1', '李四', 'kcAVKc+BvoWtRUcIwXZ72w==', '010-55558889', 13555556667, '456@abc.com', NULL, 0, 0, 1, 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 11:08:13.468', '00000000-0000-0000-0000-000000000000', '2022-02-18 11:08:13.468', '325a8861-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_user" VALUES ('b09bbb4b-a7f0-4f7a-8f3d-dbb895f3edc5', 'test', '测试账号', 'kcAVKc+BvoWtRUcIwXZ72w==', NULL, NULL, NULL, '', 0, 1, 1, 0, '00000000-0000-0000-0000-000000000000', '2021-04-11 12:14:37.000', '00000000-0000-0000-0000-000000000000', '2022-04-29 15:35:52.229', '325a892b-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_user" VALUES ('b464f199-3369-4dbd-ae7e-497224d5ea1d', 'zhangsan1', '张三', 'kcAVKc+BvoWtRUcIwXZ72w==', '010-55558888', 13555556666, '123@abc.com', NULL, 0, 0, 1, 0, '00000000-0000-0000-0000-000000000000', '2022-02-18 11:08:04.487', '00000000-0000-0000-0000-000000000000', '2022-02-18 11:08:04.487', '325a8a04-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_user" VALUES ('bacc045e-eefc-4d45-9920-82192cbabb4e', 8879, 8879, 'kcAVKc+BvoWtRUcIwXZ72w==', NULL, NULL, NULL, NULL, 0, 0, 1, 1, '00000000-0000-0000-0000-000000000000', '2022-02-18 12:03:33.714', '00000000-0000-0000-0000-000000000000', '2022-05-01 21:49:16.363', '325a8acd-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_user" VALUES ('f045968e-4eec-4a96-b0be-d84389456f10', 'zhangsanq', '张三', 'kcAVKc+BvoWtRUcIwXZ72w==', '010-55558888', 13555556666, '123@abc.com', NULL, 0, 0, 1, 0, '00000000-0000-0000-0000-000000000000', '2022-04-15 21:41:17.727', '00000000-0000-0000-0000-000000000000', '2022-04-15 21:41:17.727', '325a8baa-c9e7-11ec-a1af-002b67dcf564');
INSERT INTO "sys_user" VALUES ('fe89b5a8-7ec3-4227-848b-9eac418481c0', 'lisiq', '李四', 'kcAVKc+BvoWtRUcIwXZ72w==', '010-55558889', 13555556667, '456@abc.com', NULL, 0, 0, 1, 0, '00000000-0000-0000-0000-000000000000', '2022-04-15 21:41:17.817', '00000000-0000-0000-0000-000000000000', '2022-04-15 21:41:17.817', '325a8c76-c9e7-11ec-a1af-002b67dcf564');
COMMIT;

-- ----------------------------
-- Indexes structure for table biz_account
-- ----------------------------
CREATE INDEX "biz_account_module_idx"
ON "biz_account" (
  "module_id" ASC
);
CREATE UNIQUE INDEX "userlogonname_unique"
ON "biz_account" (
  "user_logon_name" ASC
);

PRAGMA foreign_keys = true;
